all groups > sql server (alternate) > october 2004 >
You're in the

sql server (alternate)

group:

How to upload table to sql?



How to upload table to sql? Evgeny Gopengauz
10/30/2004 5:07:17 AM
sql server (alternate): How to upload a content of a table into sql-file (the set of INSERTs)
using standard MSSQL utilities?

*** Sent via Developersdex http://www.developersdex.com ***
Re: How to upload table to sql? John Bell
10/30/2004 12:38:11 PM
Hi

See Davids links if you want individual inserts although it would be alot
quicker if there are a reasonable number of rows to use bulk insert, bcp or
dts.

John

[quoted text, click to view]

Re: How to upload table to sql? Igor Shekalev
11/1/2004 7:35:30 PM
Evgeny,

Feel free to use our DTM SQL editor (www.sqledit.com) for that purpose. It
allows you to export results of the query exeution as a set of INSERT
statements. If you want to automate this process please try out our DTM
Migration Kit (www.sqledit.com/mk) and use Export to SQL rule.

EG> How to upload a content of a table into sql-file (the set of
EG> INSERTs) using standard MSSQL utilities?

Igor Shekalev, http://www.sqledit.com, SQL editor with ODBC support

AddThis Social Bookmark Button