Script your data in a T-SQL format (which can be executed in Query Analyzer)

[Thomas]

Hi all,

i'm working with SQL Server for about 4 years, and i have ever
searching for a tool which can script my DATA in a T-SQL format to
copy them very easy from one server to another.

For example scripts like that:
IF NOT EXISTS (...)
INSERT INTO (...)
ELSE
UPDATE (...)
I have never found a tool like that, so i write a it by myself.
This software is a free version in the moment, you can download it on
my website:

http://www.sqlscripter.com

..NET Framework on your client PC is required.
Have fun with it ...

Thomas

[Erland Sommarskog]

Thomas (po********@sqlscripter.com) writes:

i'm working with SQL Server for about 4 years, and i have ever
searching for a tool which can script my DATA in a T-SQL format to
copy them very easy from one server to another.

For example scripts like that:
IF NOT EXISTS (...)
INSERT INTO (...)
ELSE
UPDATE (...)
I have never found a tool like that, so i write a it by myself.
This software is a free version in the moment, you can download it on
my website:

http://www.sqlscripter.com

.NET Framework on your client PC is required.
Have fun with it ...

I don't want to belittle your work, but the standard reference for this kind
of thing is SQL Server MVP Naryana Vyas Kondreddi's utility at
http://vyaskn.tripod.com/code.htm#inserts.

I don't think he supports UPDATE though.

--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Thomas]

Erland Sommarskog <so****@algonet.se> wrote in message news:<Xn**********************@127.0.0.1>...

Thomas (po********@sqlscripter.com) writes:

i'm working with SQL Server for about 4 years, and i have ever
searching for a tool which can script my DATA in a T-SQL format to
copy them very easy from one server to another.

For example scripts like that:
IF NOT EXISTS (...)
INSERT INTO (...)
ELSE
UPDATE (...)
I have never found a tool like that, so i write a it by myself.
This software is a free version in the moment, you can download it on
my website:

http://www.sqlscripter.com

.NET Framework on your client PC is required.
Have fun with it ...

I don't want to belittle your work, but the standard reference for this kind
of thing is SQL Server MVP Naryana Vyas Kondreddi's utility at
http://vyaskn.tripod.com/code.htm#inserts.

I don't think he supports UPDATE though.

Hi Erland,

thank you for your comment, the SP from "SQL Server MVP Naryana Vyas
Kondreddi" is very powerful ! Unfortunately only INSERTS are
supported, and in most of my cases, i need more functionality.

However, thanks for this link, good to know !

Thomas