I've been tasked with transfering all data from populated MSDE2000 database and extracting it onto a thumb drive from an XP box. They are changing out the servers from XP and MSDE2000 to Win7 and SQL2012 Express.
Then plugging the thumb drive into a Windows 7 box and inserting all the data into a SQL Server Express 2012 database that will all ready have the blank structure database existing on the Win7 box.
It's been suggested I use BCP to copy data to a csv file and then use BCP to insert the data into the blank structured 2012 Express database.
I've never done this before and was wondering if that's the best way?
Go to the complete details ...