|
SQL Script Builder is software that create a database sql script (or dump file) from any ODBC data source. The script produced will migrate the database (multiple tables selection) or create only one table and the records. Scripts are available in 5 output formats ; MySql, MS SQL, Oracle, Pervasive and PostgreSQL. SQL Script Builder is very simple to use, you just have to choose the database and the table from the list. SQL Script Builder scripts can be used on your DBMS (database management system) or uploaded on a server.
SQL Script Builder can be used for example for database migration from your Access database to MySql database, or MySql database to MS SQL database and vice versa. You don't have to transfer all database, you can if you wish only import one table at a time. There's no limits, all you need is the ODBC driver for the database you wish to import from. ODBC is a universal interface, almost every database provider support it.
There's may be a wide variety of tools that can migrate your database, without the use of SQL language, but these may not establish a successful connection between databases because of versions compatibility. With SQL Script Builder once you have established your source ODBC connection and generated the script, you can be sure this script will work on the target database because the scripts are universal. An other great thing to consider is that SQL scripts can also constitute a backup file of your database. Better management of errors warnings. A log window have been added.
|
