Home > Archive > MS SQL Server > February 2006 > Exporting sql tables and data to T-SQL statements









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Exporting sql tables and data to T-SQL statements
shija03@hotmail.com

2006-02-16, 1:23 pm

Is there any tool, either built into MSSQL or a 3rd party, that allows
me to export any SQL table and its data to T-SQL statements?

Thank you

David Gugick

2006-02-17, 7:23 am

shija03@hotmail.com wrote:
> Is there any tool, either built into MSSQL or a 3rd party, that allows
> me to export any SQL table and its data to T-SQL statements?
>
> Thank you


This feature is a part of Toad for SQL Server from Quest Software.

--
David Gugick - SQL Server MVP
Quest Software

Rick Sawtell

2006-02-17, 7:23 am


<shija03@hotmail.com> wrote in message
news:1140116013.437263.296310@g44g2000cwa.googlegroups.com...
> Is there any tool, either built into MSSQL or a 3rd party, that allows
> me to export any SQL table and its data to T-SQL statements?
>
> Thank you
>


Is this something that you are looking for?

http://vyaskn.tripod.com/code/generate_inserts.txt



Rick Sawtell
MCT, MCSD, MCDBA



Tibor Karaszi

2006-02-17, 7:23 am

Some options mentioned here: http://www.karaszi.com/SQLServer/ i...ript
.asp


--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/

Blog: http:// solidqualitylearning
.com/blogs/tibor/



<shija03@hotmail.com> wrote in message news:1140116013.437263.296310@g44g2000cwa.googlegroups.com...
> Is there any tool, either built into MSSQL or a 3rd party, that allows
> me to export any SQL table and its data to T-SQL statements?
>
> Thank you
>


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com