Converting Table Structures

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Exploring and Changing the Database Structure >

Converting Table Structures

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.

© 2019 Altova GmbH