import & export data script

minhpx · January 3rd, 2005, 10:28 PM

Hi All,

How to build export and import data script?

for each table export to 1 file as <table_name>.sql

Thanks.

jemacc · January 4th, 2005, 01:15 AM

you need to do this using

Code:

EXEC sp_GenerateScript @server = 'Server_Name',
                       @uname = 'User_Name', 
                       @pwd = 'Password',
                       @dbname = 'Database_Name', 
                       @filename = 'c:\File_Name.sql'

and you can find all the details here http://www.mssqlcity.com/Articles/Ge...eAutSP.htm three quarters down the page Example: generate script

Jaime E. Maccou