You are not logged in. Please login or register.
My Visual Database → General → database FIX
welcome everybody
I have a query
When I make a project and after a while I make updates to it, when I move the old database it does not work well and many errors appear because it does not contain the new additions.
Is there a way to update the old database to make it work properly while preserving the data?
Hello
What do you mean by 'move old bases'?
Can you show us the error messages that appear?
JB
Hello
What do you mean by 'move old bases'?
Can you show us the error messages that appear?JB
I mean I created a project and added data for a while
After a while, modifications and additions were made to the tables
When I transfer the SQLIT file to the modified program a message appears stating that the new fields do not exist
There are two solutions to this problem:
1) simultaneously edit the data structure in both the new version and the old one using the development environment.
2) when starting the program, use scripts to check for the presence of new tables/fields and add missing ones.
Hi MS2014, Salut Jean, Привет Konstantin,
What sort of changes have you made?
1. added new fields?
2. changed existing fields (changed field names, field definitions)?
3. deleted existing fields?
4. added new tables (what relationships with existing tables)?
5. changed existing relationships?
6. deleted existing tables?
The type of changes has a big impact on the size of task and the approach that you take.
Also, how many data rows do you have in tables that you've changed.
Depending on the answers to the above points, you may be able to simply copy and paste your data using something like SQLiteStudio
Just make sure you back up your database first!
Derek
.
My Visual Database → General → database FIX
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi