Click here to Skip to main content
11,706,477 members (52,629 online)
Click here to Skip to main content

To generate insert statement for user defined tables available in SQL Server 2000, through easy to use wizard.

, 23 Jun 2006 65.9K 614 27
Rate this:
Please Sign up or sign in to vote.
It will generate insert statement as per the tables selected by the user, and it also take cares of Identity inserts in the table.

Sample Image - GenerateSQLInsertScripts.gif
First Step


Second Step


Third Step

<!------------------------------- STEP 3 ---------------------------><!-- Add the article text. Please use simple formatting (

,

etc) -->

Introduction

By default SQL Server provides a facility to generate script for Database Objects. But their is no option offered by SQL Server to generate insert statements for the existing data in the tables. I faced this problem several times while creating application installer, I always had to ask someone to create insert statement for the master data or some data mandatory for application installation.

To overcome problem of manually generating Insert statements for SQL Server, I finally decided to build a wizard based utility that allows user to genrate insert scripts.

Using this tool

This tool is developed in C#, so we need to make sure we have Microsoft .Net Framework 1.1 installed on the system. It can generate sql scripts in 3 simple steps:

1. Enter connection detail for your SQL Server.

2. Select the tables, and organize them as per thier relation in the database i.e. Master should come first and then dependent tables to avoid refrential integrity error statements

3. Click on "Copy" button to copy generated statement to clipboard

Points of Interest

This component is as free as .Net Framework library.

History

1. Revised verson uploaded on 25-Jun-06  - To display truncate statements and handle UniqueIdentifier datatypes
2. Initial version added on 15-May'06

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

Vivek Singh - IN
Web Developer
India India
No Biography provided

You may also be interested in...

Comments and Discussions

 
QuestionPlease check this tool with more features Pin
Rishikesh_Singh23-Feb-12 3:57
memberRishikesh_Singh23-Feb-12 3:57 
Questionnot generating insert statement Pin
IMQ13-Apr-09 3:54
memberIMQ13-Apr-09 3:54 
AnswerRe: not generating insert statement Pin
Vivek Singh - IN13-Apr-09 6:39
memberVivek Singh - IN13-Apr-09 6:39 
GeneralRe: not generating insert statement Pin
IMQ13-Apr-09 8:54
memberIMQ13-Apr-09 8:54 
GeneralIt gives an unhandled exception Pin
jbmixed19-Feb-08 0:12
memberjbmixed19-Feb-08 0:12 
GeneralGreat Tool Pin
Russell Aboobacker31-Oct-07 2:43
memberRussell Aboobacker31-Oct-07 2:43 
Questionharinov60 requires assistance Pin
Sean Ewington24-Oct-07 4:22
adminSean Ewington24-Oct-07 4:22 
AnswerRe: harinov60 requires assistance Pin
Vivek Singh - IN25-Oct-07 0:26
memberVivek Singh - IN25-Oct-07 0:26 
GeneralSQL Scripter Pin
Member #35689139-Jan-07 4:18
memberMember #35689139-Jan-07 4:18 
GeneralSQL Server 2005 Pin
Ant6313-Dec-06 1:50
memberAnt6313-Dec-06 1:50 
GeneralRe: SQL Server 2005 Pin
Vivek Singh - IN13-Dec-06 20:12
memberVivek Singh - IN13-Dec-06 20:12 
GeneralMissing quotes for uniqueidentifier column Pin
jtseung20-Jun-06 16:49
memberjtseung20-Jun-06 16:49 
GeneralRe: Missing quotes for uniqueidentifier column Pin
Vivek Singh - IN23-Jun-06 19:56
memberVivek Singh - IN23-Jun-06 19:56 
GeneralDecimal problem Pin
AnT5120-Jun-06 3:00
memberAnT5120-Jun-06 3:00 
GeneralRe: Decimal problem Pin
Vivek Singh - IN23-Jun-06 20:01
memberVivek Singh - IN23-Jun-06 20:01 
GeneralRe: Decimal problem Pin
AnT5129-Jun-06 23:34
memberAnT5129-Jun-06 23:34 
GeneralRe: Decimal problem Pin
Vivek Singh - IN29-Jun-06 23:56
memberVivek Singh - IN29-Jun-06 23:56 
GeneralLarge databases, and another tool Pin
Sire4045-Jun-06 4:27
memberSire4045-Jun-06 4:27 
GeneralRe: Large databases, and another tool Pin
Vivek Singh - IN5-Jun-06 17:18
memberVivek Singh - IN5-Jun-06 17:18 
GeneralSource Code Missing Pin
devnet24715-May-06 3:10
memberdevnet24715-May-06 3:10 
GeneralRe: Source Code Missing Pin
Vivek Singh - IN15-May-06 16:44
memberVivek Singh - IN15-May-06 16:44 
GeneralRe: Source Code Missing Pin
Pankaj bothara jain4-Apr-07 21:29
memberPankaj bothara jain4-Apr-07 21:29 
GeneralRe: Source Code Missing Pin
Vivek Singh - IN9-Apr-07 5:41
memberVivek Singh - IN9-Apr-07 5:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.150819.1 | Last Updated 24 Jun 2006
Article Copyright 2006 by Vivek Singh - IN
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid