runal_jagtap (4/17/2013)
i have to migrate from Sql 2005 to Sql 2005..(Only 2 databases)1) I will take a backup of two databases & then copy the backup file to new serevr
2) I will restore them to the new server.
3) Will Migrate Login using Login & Password Script.
4) Will schedule all maintenecae jobs which was existing on old server.
5) Will ask developer to point all application to the New database & will confirm it works.
Else what i have to do ???
Do i need to Change compatibility mode???
Please reply soon.. i need to impelment this in 1 hour :w00t:
You have a DB migration in a few hours, and you have not planned it properly or in advance? Sorry, but that does not sound too smart.
Above steps, overall, is pretty much what you need. But If you just backup and restore, the only remaining step is fixing the SQL users via script, of course, assuming you create those logins on the new SQL instance too.
The most critical part is check connectivity, so you may ask your developer to run his application and check everything, after changing his SQL connection string in the code or ensure he is using the new SQL instance.
And no, if both versions of SQL are the same, the compatibility mode between both is also the same. You do not have to change it on the new one.