Sql Translator

Documentation

Back to SqlTran page

Creating target database

Pressing Create Database button on the ribbon starts creation of the translated objects and data in your selected target database. A cancelable progress dialog is displayed. While object creation is very fast, it may take a while to transfer all of your data.

There are three buttons you can use to create your target objects:

Create Database button

1.Drop all translated objects which already exist in the target database. Objects unrelated to translation are not dropped.
2.Create tables
3.Transfer data
4.Create indexes
5.Apply constraints
6.Create views
7.Create procedures
8.Create functions
9.Create triggers

This way, no data is lost in case your constraints behave differently in the target database, meaning your data does not comply to the rules of the target database. For example, unique keys in MySQL allow multiple NULL values, while SQL Server raises an error. With this carefully chosen order of operations, no data is lost, and you may update incompatible records before choosing to apply your failed constraints

Create Schema button

If you want to make sure all objects are created properly and don't want to wait for your data, you can opt to create schema only. You can always use Copy Data button afterwards to move the data over.

Copy Data button

When you already have your schema created, use this button to move the data to the target.

ribbon-createdb

Spectral Core Chat

Current version

ReleaseDecember 08, 2009
Sql Tran - initial release
To see detailed version history of this application, click here.