We are planning to move our SQL Server shop to VM(VMware). We still have one SQL Server 6.5 in production. What would be my course of action/path to move/migrate 6.5 to virtualized SS 2012?

It's the data that needs to be moved. The rest can be scripted/re-written if a straight migration of a DB(view, SPs.....) is not practical.

  • Your best option is to script out schema and then Bcp out and Bcp in the data. 6.5 in PROD will be news to Microsoft as well 😊.
    – Kin Shah
    May 19 '15 at 12:12
  • Thank U Kin. I'm not BCP savvy. Since we do have SS2000, would building a DTS solution that copies database objects from SS 6.5 into SS 2000 database, while remapping columns and changing data types, work?
    – user66735
    May 19 '15 at 15:34

You can update 6.5 to 2000, from 2000 to 2008 and from there go to 2012 but its much better to script out the schema and bcp the data as Kin suggests. As he seems to be to humble to link to his own post I'll do it for him: Restore SQL Server 2012 backup to a SQL Server 2008 database?


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.