943,769 Members | Top Members by Rank

Ad:
  • MS SQL Discussion Thread
  • Unsolved
  • Views: 622
  • MS SQL RSS
Jan 16th, 2009
0

SQL ,migration or export ?

Expand Post »
Hi everybody,
I've got a big pb, and I need help.....
I have to use MS SQL Server 2005 SP2 Enterprise Edition instead of
MSSQL Server 2000 Enterprise Edution and I don't know how to use the old SQL 2000 db.
Any sugestions?
Thanks for your time.
Eddysonys
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
eddysonys is offline Offline
3 posts
since Jan 2009
Jan 16th, 2009
0

Re: SQL ,migration or export ?

You have two options, both explained in books on line.
1) UPGRADE the server. This will upgrade your server from 2000 to 2005. It is a one way move and the whole server is changed. There is no rollback for this.

2) MIGRATE the database. This is a lot more difficult as the DBA (er.. you?) has to a) set up a new server (or server instance), b) make sure that all of the relevant logins / users etc are on the new server, c) copy (through SQL or DTS or SSIS or BCP) the data into a new DB and new tables (use Generate SQL Script for this) and then make sure that all stored procedures, triggers, functions and user data types are transfered as well.

The advantage of option 2 is that you can continue to use your original DB and apps while you set everything up and then you have a fall back position (the original DB).

Given the choice I use option 2.
Reputation Points: 33
Solved Threads: 9
Junior Poster
pclfw is offline Offline
132 posts
since Jun 2005
Jan 16th, 2009
0

Re: SQL ,migration or export ?

Tk's very much , pclfw!
I will keep U posted with my evolution.It seems harder , the 2-nd option, but I'll start with this one.
See U.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
eddysonys is offline Offline
3 posts
since Jan 2009
Jan 16th, 2009
0

Re: SQL ,migration or export ?

Hi!
I found that I can use :
Microsoft SQL Server 2005 Upgrade Advisor
so , with this, I can identify any problems during the upgrade.
I appreciate your feedback.
Tks.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
eddysonys is offline Offline
3 posts
since Jan 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS SQL Forum Timeline: Copying ASP.NET's default member info database
Next Thread in MS SQL Forum Timeline: Read row in a CLR Stored Procedure Without output parameter





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC