How to Make a MS SQL Server Structure Dump

When you want to reverse engineer an existing MS SQL Server database into DeZign for Databases you can connect to the database directly or you can make a database structure dump and import that structure dump. A dump will contain SQL statements to create the table and/or populate the table.

MS SQL Server provides two ways of controlling dumps through the Enterprise Manager and through a Transact-SQL command.

Transact-SQL command:
DUMP DATABASE {dbname | @dbname_var}
TO dump_device [, dump_device2 [..., dump_device32]]
[WITH options [[,] STATS [ = percentage]]]

Enterprise Manager:
You can also use the Enterprise Managerís Backup/Restore dialog box to perform dumps. You activate the Database Backup/Restore dialog box by right-clicking the database in the Server Manager and choosing Backup/Restore or by going to the Tools menu and choosing Database Backup/Restore.

Please note that ImportER Scripts only needs a dump of the table structures. The data will be ignored. Also note that default a unicode text file/script is generated by SQL Server. Please use WordPad (or another utility) to make it/save as a normal DOS text file. If the imported SQL script is not a normal text file, the ImportER will not find any table.

More information about making a MS SQL Server dump:
http://www.windowsitlibrary.com/Content/77/12/1.html



Resources

Learn Get products and technologies
  • Build your next data model with DeZign for Databases trial software, available for download directly from Datanamic's download section.