Upgrade - server 2000/sql server 2000 to Server 2003/ sql server 2005

OldtimerMCS

Upgrade - server 2000/sql server 2000 to Server 2003/ sql server 2005

by OldtimerMCS » Sat, 28 Apr 2012 04:44:23

I am converting  about 50 databases from Windows 2000 and from SQL Server 2000  to a totally new 4 processor Server 2003 with SQL SErver 2005.  I used the Database Copy Wizard in SS2005 to do the transfer and I used the object method.  After making sure the databases were big enough to hold the new Masterdatabase everything went well... except none of the stored procedures from any of the 50 databases copied from SQL Server 2000 to SQL Server 2005.  What did I do wrong   And how do i fix it.  Also, even though I changed the default database, the wizard did not reflect the new SAN location for the Data and Log files.  I had to do each one manually.