hi,
i have 2 databases (DT1 and DT2), both contains one table customers with almost identical structure, the only difference is the firstname and lastname in DT1 are char(30) and varchar(50) in DT2. i've created both tables already. i tried using SQL 2005 managment studio to do a 'import data' and it worked. all the information in DT1 were copied to DT2.
now i have to repeat the process for many databases and it would be too tedious to do it one by one. my question is, is there a script i can use to do it so that i could make a small application to automate the process?
thanks in advance.
bob
hi bob,
you can save the script generated by the wizard as an ssis or dts package
you can automate from ssis or dts
regards,
|||I addition to Joyea and the use of SSIS, which is very extensible you can also use the threepart notation to access the data from another database and write a stored procedure for this:
Select * From Database.Schema.Objectname
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
thanks for your suggestions.
Bobby
No comments:
Post a Comment