July 26, 2008 at 7:53 am
which is the best method in migration of sql server 2000 to sql server 2005
is it inplace upgrade or Backup/Restore
Please provide justification as well
July 26, 2008 at 10:10 am
This sounds like a test or interview question, and you haven't really shown that you put any effort into thinking about it. Also, it's a general question.
What options are there? what have you considered? and how do those relate to your environment? Do you have restrictions or SLAs/needs that you need to meet for your server?
July 26, 2008 at 11:37 pm
You can do it by using backup option. Take the back up of your db and restore it ..
dont forgot to change compatibitily level of the database to 90.
Else you can create a database in sql server 2005 with schema as in the older version
and using DTS package you can migrate the data.
Regards,
Venkatesan prabu .J
Thanks and Regards,
Venkatesan Prabu, 😛
My Blog:
http://venkattechnicalblog.blogspot.com/
July 28, 2008 at 3:19 am
You can create same database name in sql2005 and use sp_attach to upload dataabase file and log file for the same
July 29, 2008 at 8:13 am
It is a matter of preference. You can also detach from the 2000 instance and then attach to the 2005 instance. It typically takes a couple of minutes for it to perform the conversion. This is obviously much faster than doing a restore. Once you go 05 you can't go back though. I would just be sure to have a good backup before doing so.
July 29, 2008 at 12:56 pm
Hi,
As said in the previous comment, its actually the requirement and the environment which decides what to go for. There are two ways of it,
1. In place upgrade
2. Side by side upgrade
If the the same system (server) is to be used for SQL server 2005 where SQL server 2000 is used, then you should go for the in place upgrade. You might need to think of using the MS upgrade advisor for doing this. Installing the newer version of the SQL server will upgrade it from 2000 to 2005. I am just giving a pointer here and there are lot of iinformations available on BOL which will talk about even all the other server objects...
If another system is going to be used for hosting SQL server 2005 then it will be a case of side-side by upgrade. Here comes the question of detach/attach, backup/restore.. Its upto the situation where you are in which decides which is best for you.
I have done the upgrade recently which was a case of side-by-side upgrade.
Regards,
Pra
---------------------------------------------------------------------------------
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply