SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Upgrading a Database SQL 2000 to SQL 2005


Upgrading a Database SQL 2000 to SQL 2005

Author
Message
SRDEV
SRDEV
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 28
This article certainly highlights the difficulty of performing quality technology services when basic communications skills are substandard. This article is a difficult read, not for the technical content, but for the grammatical errors, poor sentence structure and even spelling mistakes. While the author's technical skills may be adequate, writing such an article to build a reputation, gain clients and impress others may have a very different effect. Such an article should demonstrate a certain skill level in two areas, technology and communications. This author has one. We should, and this board should, strive for excellence in both.
mamta patni
mamta patni
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 1

Nicely written article, gives a fair idea about SQL database upgrade.

keep it up !!

Mamta


Lee Davis-285380
Lee Davis-285380
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 1

The article is complete and it asissted me in doing the upgrade. I've asked my fellow consultants in my company to consider this article as the best practices for our team.

Thanks for the hardwork that was necessary to create this article!!


Carlos Sepulveda
Carlos Sepulveda
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 19

Besides Sachin's guide, I'm also reviewing book "Microsoft SQL Server 2005 Unleashed" (SAMS pub) for the proper upgrade path, and find the information about Fulltext indexes conflicting.

While Sachin states Fulltext indexes should be completely removed before upgrading and recreated, the Unleashed text states these are taken care of in both Side-by-Side and In-Place upgrades:

From page 208 for Side-by_Side: "You might be wondering how the [Copy Database] wizard handles your full-text catalogs. Rest assured, they are imported by default during either a restore, an attach, or via the Copy Database Wizard..."

From page 217 for In-Place: "...When your upgrade of the database engine is complete, it is recommended that you perform the following on all databases (also recommended for side-by-side migration): -Repopulate your full-text catalogs. (This is automatically done for databases where Full-Text indexing was enabled prior to the upgrade.)..."

I did not find any reference in the Unleashed text about removing the full-text indexes prior upgrading at all.

What gives???

Thanks for your replies. Great article by the way.

Charlie S.


Dinesh-455184
Dinesh-455184
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 1
Article is well structured, concise and to the point. It reflects a competency level of an author in this topic. I find it interesting and easy to digest inspite of a fact that the database upgradation has never been my cup of tea.

I really wonder what would happens to a pre-compiled stored procedures which have been created by a user? Would there be any impact on those stored procedures ?

Keep writing more stuff (:-

Regards
Dinesh
kprabhakar1978
kprabhakar1978
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
Points: 37 Visits: 29
[font=Verdana]Hi,

I restored SQL 2000 Database to SQL 2005 and wanna "Repopulate all Full Text catalogs".



Please let me know how to do this.[/font]
jrodolfoa
jrodolfoa
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 35
The document is excellent!!!

I need something like that, but i need to do a Side by Side Migration.

Could you give some tips, best-practices,...

Thank youWink
victsun
victsun
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 18
Hi,

Planning sql server 2000 upgrade to sql server 2005. I did a test side-by-side upgrade, installed the 2005 instance on the same box. Realized that the databases on the 2000 instance were automatically replicated to sql 2005. I did backup on sql 2000 and restored to sql 2005. Realized that when i dropped the DBs in the 2000 instance the same DBs in the 2005 instance were also dropped.

Please help
sachinsamuel1
sachinsamuel1
SSC Journeyman
SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)

Group: General Forum Members
Points: 82 Visits: 3626
In side by side upgrade, sql server 2000 database never gets upgraded automatically. SQL 2000 Database need to be manually ported to the new verstion.

I think, you viewed the old instance of SQL server 2000 using SQL server Management studio and thought it got upgraded. And then from Enterprise manager you droped the same database Sad.

I hope you have the backup. Restore the backup in the new instance you created and then change then compatibility level as mentioned in the document.

Let me know incase of any further query.

Regards
Sachin



victsun
victsun
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 18
Thanks Sachin,

I realy apprecaiate your timely response. I did a restore to ANOTHER location, dropped the old DB in sql 2000, and the instance in 2005 was dropped asl well.
I will appreciate if you give me a step by step guide of how to do side-by-side upgrade using BACKUP of the DBs in the 2000 instance and RESTORE to the 2005 instance.

I have two issues raised by upgrade advisor. They are:

1. Outer join operators *= and =* are not supported in 90 compatibility mode

2. Upgrading will cause Full-Text Search to use instance-level, not global, word breakers and filters by default

3. Column aliases in ORDER BY clause cannot be prefixed by table alias

I will appreciate a quick responce. I am already in the project and need to resolve these issues.

Regards,

Victor
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search