var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: importing into databases
Hi. I need to create a bunch of databases then import the data from old databases into them. I know how to do it with the GUI. Is there a way to do it with SQL statements or from the command line? I need to script it so I'm looking for an alternative to the GUI.
You can use the BCP utility to transfer data. This is a commandline utility.
Alternatively, you can use the import/export wizard, and save the resultant DTS package, but it is a pain to modify later on.
Where are the databases?
Which GUI? You may be able to save the operation of the GUI wizard as a package.
How about a direct SQL 2000 to SQL 2005 import. Is there a command line tool or SQL commands to do that?
If you are just wanting a copy your database from 2000 to 2005, you can detach the database file on the 2000 server, and then attach it on the 2005 server. It will upgrade the file when you attach.
I prefer backing up and restoring, myself. The detach re-attach route doesn't give you enough in the way of back out options.