March 26, 2010 at 8:50 am
Hello,
Im in the process of upgrading my SQL 2000 databse to SQL 2005. We currently have a bunch of DTS jobs and store Procedure, Views and Function that need to be upgrade.
I ran the Upgrade Advisor, the results advised me to edit a couple of DTS job that are not compatible with SQL 2005.
My concern is upgrading the database, I'm aware of the two different type of upgrade. If I Dettach and Attach the databse to the new SQL server consider an Upgrade? I know that the compatibility has to be set to 90 once SQL 2005 once the database is completely attached.
Also what about the database security, does it have to be recreated on the SQL 2005 box or does SQL 2005 import the databse security to the root security?
March 26, 2010 at 8:53 am
like most things, it depends... If you go the detach/attach route, then no, your security will not go with the database. All of the users in the database will transfer, but the logins to the SQL instance will not and you'll need to script them out or re-create them on the 2005 server depending on which ever is easier for you.
-Luke.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply