Trackhappy
IS-IT--Management
We have new hardware for our SQL 2000 server. It has a myriad of small databases on it, all from different sources. Is there an easy way to migrate the whole thing to a new platform, or should we build the new server (new name) and migrate each database separately? I guess the main concerns are security (SQL security), how does SQL 2000 handle renaming the new server once built to be the same name as the old?, ODBC links etc.
I am favouring separate moves, only because I have never moved a SQL server in big-bang fashion.
Any hints, experiences, links to documents? All the ones I have found are migration from SQL7 to SQL 2000.
Thanks
Glenn.
I am favouring separate moves, only because I have never moved a SQL server in big-bang fashion.
Any hints, experiences, links to documents? All the ones I have found are migration from SQL7 to SQL 2000.
Thanks
Glenn.