Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
osirisa
Constraint Violating Yak Guru
289 Posts |
 Posted - 2013-03-20 : 21:59:49
|
| First Thank You for your help. The scenario the company is upgrading to SQL Server 2008 from SQL Server 2005. I need to replicate (copy) databases, link servers, roles, permissions, etc from sql server 2005 to the new version. Can anyone tell me the easiest, more simple, safe and secure way to do this. If is possible I would like to copy everything at once.Thank You.... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2013-03-21 : 05:26:43
|
| Agree with visakh16..But I want to give one more suggestion is that first you should download and run the Microsoft SQL Server 2008 Upgrade Advisor. Microsoft SQL Server 2008 Upgrade Advisor analyzes instances of SQL Server 2005 to help you prepare for upgrades to SQL Server 2008. |
 |
|
|
|
|
|
Copying all Database, link servers, roles, etc.