DTS import/export
Home > IT Answers > SQL Server > DTS import/export
Db23
230 pts.
0
Q:
DTS import/export
DTS Import/Export Wizard, BCP Utility
Hi,

I was wondering if the DTS import/export also recreate the table, the reason I am asking this I want to recreate a database using the Generate SQL Script but change the collation of the columns of the table, then import the data from that database to this new database. If it does recreate the table, should I be using BCP Bulk insert instead?

Thanks.
ASKED: May 21 2009  3:18 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Db23
230 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Last Answered: May 21 2009  3:18 AM GMT by Db23   230 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Valuable Internet Information » DTS import/export   0 pts.  |   May 25 2009  3:55PM GMT

[...] More here:  DTS import/export [...]

 
0