Products / DBWScript

The DBWScript is the software for MS Access databases to generate sql scripts.

It generates MSAccess sql dialect scripts to recreate MDB/ACCDB databases.
It generates MSSQL scripts from MSAccess files. See how to convert MSAccess database to MSSQL script.
It converts MSAccess database to MySQL script file.

It is nice to have the Data Definition Language (DDL) script working with a database. It serves for such aims as:
- to get the DDL script of the MS Access database
- to get the data/content script
- to recreate a database schema (tables, fields, indexes, keys, constraints)
- to store the creation script in the source control as a text file
- to quickly modify the creation script and create a new database
- to get a part of the DDL script and to use it in an application
and solve other similar problems.

Requirements:

Our software works with MS Access 2007/2010/2013 databases and requires Microsoft Jet database engine.

If you have x64 version of Microsoft Office, please install 64-bit version of Microsoft Access Database Engine 2010 Redistributable and use 64-bit version of our software.

If you have 32-bit version of Mircrosoft Office, please install 32-bit version of Microsoft Access Database Engine 2010 Redistributable and use 32-bit version of our software.

The DBWScript helps to solve these tasks and converts the MDB file structure to the creation script. To do this, simply choose a MS Access database and the script will be generated.

DBWScript screenshot

DBWScript can be used with the command line parameters. It allows you to run it using the build system like ant, nant, msbuild and so on.

Usage: DBWScript <mdb file> <sql file> [option1] [option2] ...

/s	- generate the database schema
/d	- generate the database data
/target	- msaccess, mssql, mysql
/utf8	- write the script as utf-8 file
/utf16	- write the script as utf-16 file
/e	- show an error message in the console instead of the message box
/p <password>	- database password
/un <name>	- user name
/up <password>	- user password
/sd <path>	- system database
/t <table name >	- process a single table

If you start it from the command interpreter (batch file), you may need to use start /wait to force cmd.exe to pause. E.g.
start /wait DBWScript database1.mdb script.sql

The distribution kit also includes DBWConsole, the tool to execute the DDL scripts. It has a user friendly interface and is simple in use. You can open the existing database File > Open Mdb or create a new one File > Create Mdb.

Then put the creation script into the window or load from a file using File > Open SQL.
And then run the script pressing the Run button.