SQL Script Builder

How can I disable debug mode? (Get full table).
1. The option to disable debug mode is located on the left panel of the main interface, click on the checkbox and you will get the complete tables.
What is SQL Script Builder ?
1. Ever wanted a tool that can migrate any database? 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.
How to use SQL Script Builder ?
1. To use SQL Script Builder, simply follow these steps :
  
  First be sure you have set a valid system source (DSN).
  
  There's three ways generating SQL scripts, first one is :
  
  1. Select the source in the treeview.
  2. Click on the blue button on the toolbar.
  3. Select table(s) then click the Done button.
  4. Choose or not to add foreign key(s).
  5. The script will be generated. You can save the script in a SQL file.
  
  Second way is :
  
  1. Right click on the data source in the tree view, options menu will appear.
  2. Click on generate SQL, the list of available tables will be listed.
  3. Select table(s) then click the Done button.
  4. Choose or not to add foreign key(s).
  5. The script will be generated. You can save the script in a SQL file.
  
  Third way is :
  
  1. Double click on the data source in the tree view, the tables will be listed.
  2. Double click on the table, the script will be generated.
  3. You can save the script in a SQL file.
  
  You can set additional features by selecting the type of SQL Script you want (MySql MS SQL Oracle Pervasive or PostgreSQL).
  
  The script produced can be used for example to create a new table on a remote server
How do i set up an ODBC Source (DSN) to be used with SQL Script Builder.
1. (If you are using Windows 7 with an admin password, be sure you start the app using right click and choosing 'Run as administrator' before adding sources.)
  
  1. In the menu go to : Connection -> ODBC - Add System Sources.
  
  2. Choose the ODBC Driver and enter the name you want to be used.
  
  3. Click on the Create button.
  
  4. Set the parameters for your new data source and click OK.
  
  5. Repeat step 2 to 4 for each data source you wish to add.
  
  6. Click Done button when you have finished adding your sources.
  
  You're set !
Why certain tables can not be processed or create an error message ?
1. The data of tables can not be processed if they have errors in it. Be sure there's no errors in your table data before processing it.
What are the things to know about 32 bit vs 64 bit version ?
1. First thing to know is that there is 32 bit and 64 bit version of ODBC drivers. Generally you cannot access a 32 bit data source with a 64 bit ODBC driver.
  
  Second one is that 32 bit version of SQL Script Builder can only set and access 32 bit ODBC sources, and 64 bit version of SQL Script Builder can only set and access 64 bit ODBC sources.
  
  That is why there's a 32 bit and a 64 bit ODBC data sources manager on x64 Window OS, the 64 bit version is the default one. To see the 32 bit version on 64 bit Windows use C:\Windows\SYSWOW64\odbcad32.exe (C:\%windir%\syswow64\odbcad32.exe)
Where do I enter my database password ?
1. Go in Options -> More options -> login Tab.
  
  Choose the DSN for wich you want the password to be set, then type the user name and password that will be used each time you connect to this database or access its table. You will have the choice to keep this info in computer or just keep it in memory during the session.
How do i create database files like Access mdb from my source ?
1. To create database files, Right click on source in the treeview (left panel) you will then have many more options for that source.
The source I want is not listed in the TreeView.
1. First be sure you have added a SYSTEM DSN and not a USER DSN, you have to choose the good tab in ODBC Manager dialog.
  
  (If you are using Windows 7 with an admin password, be sure you start the app using right click and choosing 'Run as administrator' before adding sources.)
  
  If SQL Script Builder do not list the available data source name (DSN) you want, it is possibly because it cannot access system registry most of the time for security reasons. Ask your system administrator about your registry access rights.
  
  To see all valid sources go to Connection -> ODBC and look under the SYSTEM DSN Tab. To create a link (DSN) to a table located on a database see the topic :
  
  How do I set up an ODBC Source (DSN) to be used with SQL Script Builder.
  
  You need to be sure that MDAC version 2.1 or later is installed on the system where you plan to run the application. MDAC is automatically installed with software such as some versions of Windows and Internet Explorer version 5 or later. It is recomended to have the latest MDAC version installed, an update is available from Microsoft web site.
My Excel tables cannot be listed.
1. If you are importing from Excel file you may have to also enable 'Extract system tables' in options ->More Options-> misc tab.
Importing/Exporting files from blob fields.
1. You can import files contained in blob fields. To do so go into Options -> More Options -> BLOB Tab, and activate "Extract files from BLOB fields".
  
  An atempt will then be made to extract files from source table. These files will be saved in the path defined on this options page. Note that when this option is activated time for script creation is realy increased, especially if your files are very large, so be patient and be sure you have a large amount of free space on your hard drive.
  
  The next option you can activate is "Store blob file in destination database as raw binary". With this option enabled the sql script created will not store the path to files in text field, but actually load the files in the database, so you will be able to delete the files on disk after sql execution. This option does not work for CSV files, XML files and Pervasive. Note that if this option is not enabled files will be extracted, but only path to files will be put into table, so files will have to obviously remain on disk.
  
  Method : You can also select the type of files you want to be imported. Restrict : SQL Script Builder tries to identify only the type of file selected contained in the blob field. Filter : SQL Script Builder tries to identify all file types he knows and then discard the types not selected. Error of identification can occur in both cases when for example blob is an OLE embedded object.
  
  Hints :
  
  Select as few file formats as possible (When Filter).
  
  Extract as separate tables if different file types is found on separate tables.
  
  Use Restrict only if you are sure that there's only those type of files in that table.
  
  If you are not sure, verify extracted files by opening them in their associated editor.
  
  Example :
  
  A Jpeg image file can be found in an MP3 file. So if a table have MP3 and jpeg files choosing filter (mp3 and jpeg) is mandatory, because if you only choose jpeg and Restrict, a jpeg file instead of MP3 can be found and extracted in place of the MP3.
  
  Note : When looking for MP3 files, only ID3 encapsulated files will be found.
Batch Conversion (Many tables)
1. To create the script for a selection of tables of a given source, right-click your source and choose 'Generate SQL', then you will be able to select a group of tables to generate SQL from.
Importing from .csv and .txt delimited files.
1. You will get better results if the first line in the text file contains the columns names.
What is SQL and how I execute it ?
1. SQL (Structured Query Language) is a structured query language that allow users to extract and manipulate data. But how can we obtain a SQL script that create a table and its content from a table contained in a database ? SQL Script Builder does just that.
  
  Execute SQL in MySql :
  
  To execute scripts on MySql locally we recommend using PHPMyAdmin installed on the server supported by PHP, but if you don't have a server set, you can use HeidiSQL or you can start mysql.exe located in the bin directory of your MySql installation directory. Then, type :
  
  mysql> source c:/scripts/myscript.sql;
  
  where "myscript.sql" is the file created with SQL Script Builder.(In he test i made using this method i had problems dropping the table...), You will also possibly have to specify database in your script when executed this way. (Options -> More Options -> Misc Tab)
  
  Execute SQL in MS SQL Server :
  
  To execute SQL in MS SQL Server open the "SQL Server Management Studio". Connect to MS SQL Server, in menu click on "Open" then "File", then select the script file created using SQL Script Builder. After that click on "Execute". You can also paste the script into a "New Query" then Execute it.
  
  You can also use the SQLCMD command line utility:
  
  The following runs the C:\MyScript.sql script from the command line and outputs the queries and results to a file located at C:\MyResults.txt.
  
  Example : C:\Windows>sqlcmd -S MYSERVER\SQL2008 -i C:\MyScript.sql -o c:\MyResults.txt -e
  
  Execute SQL in Oracle :
  
  Scripts can be executed in SQL Plus.
  Use GET filename or START filename. GET filename places the file into the buffer. START filename executes the commands in the file.
  
  Example :
  
  SQL> START c:/scripts/myscript.sql;
  
  Execute SQL in Pervasive :
  
  Go into Pervasive Control Center, select a database, then "Execute SQL Query" in tool bar will become available, Click on it, a query window will appear, in the "File" menu choose "Open SQL Query" then select your script file created with SQL Script Builder. Be sure to set in "Tools" -> "Properties" the statement separator ";". Then qo into "Tools" -> "Query" -> "Run All Sql Statements".
  
  Execute SQL in Postgres :
  
  Start pgAdmin, connect by clicking on server name, then choose database, then "Execute arbitrary SQL Queries" will be available from tool bar, click on it, a query window will appear, choose "File" from menu, then "Open", then choose the script file created with SQL Script Builder, when done click on execute file.
Date Field Formatting
1. With SQL Script Builder you have three options about date fields (Options -> More Options -> Dates tab) :
  
  1. Convert to string.
  
  Date fields will be converted to text fields.
  
  2. Leave them as they are.
  
  SQL Script Builder will try to use the proper date field format.
  
  3. Use date formatting.
  
  A great new feature of SQL Script Builder is date field formatting. In order to handle date fields correctly sometimes SQL engines need to know the format of input date fields.
  
  To do so they use a format string which indicate in which order day month and year are appearing so they can convert it to fit the way they read them.
Can this program also create the relations between tables ?
1. SQL Script Builder support only the creation (not importation) of FOREIGN KEY tables-relations, and importation of PRIMARY KEY constraint. (sometimes the connection do not import PRIMARY KEY).
  
  If more than one key is found, and target SQL support only one Primary Key per table, Only first key found will be kept.
  
  Other things it do not support :
  
  NOT NULL, NOT NULL UNIQUE, etc...
  
  You will have to simply add these constraints by typing them manually, before executing the script.
  
  You can also add these extra info, after you have created the table (executed script), directly to the table on your DBMS (database management system) using their control panel.
Drop Table Statement
1. The drop table statement can be added to the script by enabling Drop Table below ODBC system sources
Spaces in table and column name
1. Spaces in table name and column name can be preserved (but this is not recommended) if you disable the option to replace spaces with underscores '_' in options -> More Options under 'Misc' tab.
How information is kept into database ?
1. The information in a database is kept into tables. The three main characteristics that have most tables are : columns, lines (records) and a name. Columns headings describes the type of information that columns are keeping. Data is stored line by line.
What is ODBC ?
1. The Microsoft® Open Database Connectivity (ODBC) interface is a C programming language interface that makes it possible for applications to access data from a variety of database management systems (DBMSs). The ODBC interface permits maximum interoperability - an application can access data in diverse DBMSs through a single interface. Furthermore, that application will be independent of any DBMS from which it accesses data. Users of the application can add software components called drivers, which interface between an application and a specific DBMS. To find more ODBC drivers you can visit our downloads page. Link to the Microsoft ODBC page
How to get my tables (Sheets) listed with MS Excel as source ?
1. To get more tables (Sheets) listed with MS Excel as source go into Options -> More Options -> Misc Tab, Then activate 'Extract system tables'. More tables will then be listed.
  Note that when working with Excel tables (Sheets) with this option activated the first row will be used for fields names, so verify that your Excel file meet that requirement.
  This option is experimental and have not been tested on other types of sources yet, so strange error messages can occur when this option is enabled and used on other types of sources.

David Birebent on Facebook