DatabaseSpy allows you to convert the structure of a selected table so as to fit the syntax requirements of a database kind other than the table was initially created in. This can be done either in the Online Browser or the Design Editor by using Drag and Drop. DatabaseSpy creates a change script that must be executed to commit the changes to the database.
The following restrictions apply to the conversion of database tables:
•Properties that would require parsing (for example, check constraints or triggers) will not be converted
•Foreign keys will not be converted
•Indexes will not be converted
If database items cannot be converted into the target database, a warning message will be displayed in DatabaseSpy.
To convert the structure of a table to a different database type:
1.Open a Design Editor window for the target database. (The database connection details are always indicated in the lower left corner of Design Editor, see also Changing the Data Source of Design Editor.)
2.Optionally, display the source table in a Design Editor window of the source database.
3.Select a table in the Online Browser or Design Editor and drag it into the Design Editor window of the target database.
4.Execute the change script.