SQL Options
Figure 7
Table Name – The name of SQL table
Add “Create Table statement” – in the title section it adds the following SQL text in the exported file
CREATE TABLE [TableName] (TableFieldDefinition);
Commit Options – some SQL servers provide the opportunity of saving the data at a certain stage of the implementation of the script. This can be done through the Commit SQL instruction. For example, you can save the result every 10 entries – then, for Commit after, you should set the value of 10. If you want to perform the Commit operation after the last entry as well then you should choose Commit after script.
An example of exported file with the following settings:
Figure 8
COMMIT;
INSERT INTO [MyTable] ([DisplayName],[LastName])
VALUES ('A. Ferreira','Ferreira');
INSERT INTO [MyTable] ([DisplayName],[LastName])
VALUES ('Albert Hajrizaj','Hajrizaj');
COMMIT;
....
INSERT INTO [MyTable] ([DisplayName],[LastName])
VALUES ('WENETU',null);
COMMIT;