Generate SQL scripts easily from MS Access database (*.mdb, *.accdb)

FOR IMMEDIATE RELEASE
(Free-Press-Release.com) March 13, 2010 -- Rather than hand-writing the SQL CREATE statements (which will be long, tedious, and error-prone process), MDBScript is a powerful SQL script generation utility for any MS Access database (*.mdb, *.accdb). Easily generate SQL scripts for any objects existing in a database, including tables, records, primary keys and foreign keys. Run and execute the generated SQL scripts to re-create or deploy your database at your convenience.

How to Generate SQL Script:

1. Run MDBScript. Click the "Generate Script" button, a script generation dialog will appear.
2. Click the "..." button to select your target database, and type your username and password if the database is password protected.
3. Click the "Connect" button to load all the tables of your target database, then select the tables you want to script.
4. Check the "Tables" option if you want to generate CREATE TABLE statements for your selected tables; or check the "Data" option if you want to generate INSERT statements for records in your selected tables; or both of them.

5. Click the "Generate" button, it will generate the scripts instantly. You can save the generated scripts to a .sql file by click the "Save to File" button.

Learn more about MDBScript
http://www.mdbscript.com/

accdb     Access     generate sql script     MDB     mdbscript     scripts     sql script