[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

DTS SQL 2000/2005

Hi,

I need to move some databases from sql 2000 to sql 2005. If a backup and restore the best method? I have tried to DTS but cannot connect either way? I would also like to take the individual logins across. I need to keep the permissions rather than recreate the logins. Can you please advise the best way to do all this. Thank you
0
monarchit
Asked:
monarchit
  • 3
  • 2
1 Solution
 
monarchitAuthor Commented:
Ok, once i have done that, do i then run that script on a newly created database on a different sql server? or do i restore the DB and then run the script?
0
 
monarchitAuthor Commented:
That didnt work. It did not map over the SQL logins either? It created teh tables etc but user information was missing to start with?
0
 
EmesCommented:
This may also work

To restore a SQL 2000 database on SQL 2005

create a new database in 2005 with the same name and compatibility set for SQL 2000 or the version you want to restore from.

restore this database with options 'overwrite existing database'
0
 
monarchitAuthor Commented:
None of these solutions worked. Closed
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now