Sometimes its very useful in development to return a database back to an initial state, one way of doing this is to simply develop a SQL file to clear down the necessary tables and insert the required data. DB Data Scripter automates this process by producing the .SQL file straight from the current contents of a particular database.

Scripting a Database

Select the DSN you want from the 'DSNs' DownDrop. The tables within the database are listed in the left hand ListView. Move the tables you want to script to the right hand ListView, using the four CommandButtons in the middle. You can use the bottom two CommandButtons to reorder the script tables.

All the other details are defaulted from DB Data Scripter Options. The 'Username' and 'Password' are required to access the database. A location for the .SQL file must be given and select either 'Clear Down All Tables' in the database or just the tables in the script list, 'Clear Down Script Tables'.

Note: Only MS SQL Server databases are currently supported.