• Home
• Products
• Sql Tran
• Data

Data

For complete database migration, we need all of the source data moved over. When writing the target database, you can choose whether you want only database objects created, only data copied (which requires tables objects to exist, of course), or all.
Most of users want everything moved at once. We have designed our target database creation process to write database objects and data in this order:

1. Existing objects are dropped before creating objects with the same name
2. Tables are created
3. Data is copied to newly created tables
4. Indexes are built
5. Constraints are applied
6. Views are created
7. Procedures are created
8. Functions are created
9. Triggers are created
   

This way, no data is lost in case of index or constraints errors. Such errors might happen because MySQL and SQL Server, for example, handle unique keys differently. MySQL allows for multiple NULL values, while SQL Server doesn't. We believe it should (as NULL != NULL), but that's the way it is... Of course, if errors do appear after the target database creation, you will be able to inspect them and do the needed corrections to have the second screen appear.