Generate Definition and Export

Sirkel Toolbar Generate Definition and Export
With this screen you can create a definition of a table in sql instructions and statements. It also creates the necessary Insert – Update statements based on the records present in the chosen table. As an example I will take a table 'Address' from the AdventureWorks database.
Generate Definition and Export: selection and options
Option / SelectionMeaningAction
SirkelData Generate Definition and Data - Table SelectionYou can choose a table with schema from a list of all tables in the database. 
SirkelData Generate Definition and Data - File SelectionHere you have the option to create or select a file. 
Sirkel Generate Definition and Data Table DefinitionThis creates a structured SQL statement.DROP TABLE Person
...
CREATE TABLE [Person].[Person]
...
Sirkel Generate Definition and Data SQL SelectionChoice between Insert or Update statement.INSERT INTO ... UPDATE...
Sirkel Generate Definition and Data SQL CountsChoice if you want to keep a counter.SET @InsertCnt = @InsertCnt + 1 SET @UpdateCnt = @UpdateCnt + 1
Sirkel Generate Definition and Data Record ExistCheck whether record exists or not.SELECT @count = COUNT(*) FROM [Person.Person] WHERE ...
IF @count = 0
Sirkel Generate Definition and Data Begin EndStart and end for each statement either an Insert or an Update.BEGIN
END
Sirkel Generate Definition and Data Identify SET IDENTITY_INSERT Person.Person ...
Sirkel Generate Definition and Data Editor See the example below.