January 14, 2011 at 2:16 pm
Hi everyone,
Currently we have several databases on the following system:
Windows 2003 Enterprise 32-bit
SQL Server 2005 Enterprise 32-bit
New server will be:
Windows 2008 R2 64-bit
SQL Server 2008 R2 64-bit
As part of the migration, I am going to detach the user databases on the 32-bit server and move them over to the 64-bit server. My questions are:
1. Should I be moving the master/msdb databases as well?
2. What is the best way to move the user logins?
3. Best way to move the permissions for each database?
4. Best way to move the jobs?
5. Best way to move the SSIS packages?
Thanks in advance!
January 14, 2011 at 3:23 pm
This link has a great whitepaper about that migration:
http://www.microsoft.com/sqlserver/en/us/product-info/why-upgrade.aspx
Fabrício França Lima
MCITP – Database Administrator
https://www.fabriciolima.net/Blog
January 15, 2011 at 11:16 am
1. Is this the same server name?
2. sp_help_revlogin
3. permissions move. Or are you talking at a server level? You'll need to script these out.
4. script them out
5. save to file system, reload.
January 20, 2011 at 1:10 pm
Thanks a lot, have downloaded the white paper, looks very detailed!
January 20, 2011 at 1:17 pm
you're welcome. This whitepaper is really great.
Fabrício França Lima
MCITP – Database Administrator
https://www.fabriciolima.net/Blog
January 21, 2011 at 8:56 am
As an added caution, be sure to check how you are accessing the server. You can run into problems when going from 32 bit to 64 bit SQL Servers because you cannot use a 32 bit ODBC driver to connect to a 64 bit SQL Server. I wrote about my experience with this at http://shaunjstuart.com/archive/2010/09/too-many-bits/[/url].
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply