Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Moving a database from one server (SQL 2000) to another (SQL 2008)

Status
Not open for further replies.
eilob

eilob

Programmer
Mar 28, 2007
54
IE
Hi all,

I have a database in SQL 2000 that has to be moved to another server in SQL 2008.
Please if someone could tell me the best approach to migrate this database.

Thanks

Eilob
 
Sort by date Sort by votes
Take a look here for a very good suggestion. thread183-1619522

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Upvote 0 Downvote
What about DTS pacakges? I know that there is some legacy support in 2008, so can you just move everything over and then re-write in SSIS one at a time?
 
Upvote 0 Downvote
I havent done this before, could you please let me know the steps, thanks
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
377
Volvere
V
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
359
pjw001
pjw001
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
243
Mike Lewis
Mike Lewis
grnzbra
  • Locked
  • Question
T-SQL Dialog Box
Replies
8
Views
221
Chris Miller
Chris Miller
Andrzejek
  • Locked
  • Question
Eliminate pesky [ ] in SQL Management Studio
Replies
5
Views
264
SaltyTheFrog
SaltyTheFrog

Part and Inventory Search

Sponsor

Back
Top