SQL Script Builder – программа для создания SQL скриптов из любого носителя ODBC данных. Программа создаст и таблицы, и массивы. Конечные файлы формируются в пяти возможных форматах: MySql, MS SQL, Oracle, Pervasive и PostgreSQL. Программа чрезвычайно проста в использовании – достаточно выбрать базу данных и таблицу из списка. Данную программу можно использовать для конвертации баз данных: например, из Access в MySQL, из MySQL в MS SQL и наоборот и т.п. В результате вы получите скрипт, содержащий и то и другое, и готовый к размещению в системе менеджмента баз данных (DBMS) или на сервере.
***********************************************
SQL Script Builder is powerful software that create a SQL script (or dump file) or database file, from any ODBC data source, a script that can be used on your DBMS (database management system) or uploaded on a server. The script produced will create the table and the records. Scripts are available in 5 formats ; MySql, MS SQL, Oracle, Pervasive and PostgreSQL , and files comes in Access mdb, Excel csv and MS xml. SQL Script Builder is very simple to use, you just have to double click the database and the table from the tree view.
SQL Script Builder can be used for example to convert 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.
OC: Windows 98/ME/2000/NT/XP/Vista
Интерфейс: English / Francais
Размер: 822 KB
