Moving SQL Database from SEManager to SQL2008 or 5 Express
Posted on 2013-10-23
Hi, I have an older 2003 server running a database on Enterprise Manager. I want to copy this to either an SQL Express instance on another 2003 server or ideally onto a SQL server running 2008R2.
When I ran a move/copy wizard on the server, but it could not find my other network servers. So I ran the Register SQL Server Wizard, it found both or the other instances but an error occurred stating: "to connect to this server you must use sql server management studio or sql server management objects".
Could someone please provide a blow by blow breakdown of how I can accomplish this, with any gotcha's on the database upgrade process so when attached on the new server my users do not have any connection issues.
Thanks in advance to all answers :-)