September 16, 2011 at 1:16 pm
We're going to migrate to SQL 2008. So, I'm going to do BCP OUT to the local drive, copy the file over to the destination server and then I'll do a BCP IN. What rights will I need both on the source as well as the destination server?
September 16, 2011 at 1:40 pm
Sunny,
Maybe I don't understand your question, are you sure you want to use BCP for migration? How about creating a backup the current version of the database and restore it to the SQL 2008 server then upgrade it to 2008 (this is an option under the database in SSMS)
Steve
http://stevefibich.net
http://utilitydb.codeplex.com/
September 16, 2011 at 2:02 pm
Steve Fibich (9/16/2011)
Sunny,Maybe I don't understand your question, are you sure you want to use BCP for migration? How about creating a backup the current version of the database and restore it to the SQL 2008 server then upgrade it to 2008 (this is an option under the database in SSMS)
There's a space issue and also out of 100 huge tables only 10 will be migrated to SQL 2008. That's why I chose BCP.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply