SQL Upgrade 2000 to 2008

Smasher · #1 (**permalink**) 11-04-09, 12:19

I have to upgrade a database from SQL 2000 to SQL 2008.
There are several sources of information on the matter available, but I was wondering if anyone here had any advice for me.

Are there any pitfalls or anything else to watch out for?

PMASchmed · #2 (**permalink**) 11-04-09, 12:24

DTS to SSIS ?
Unsupported SQL (i.e. old join syntax in where clause vs. ANSI )
"with" in hints
etc.

Smasher · #3 (**permalink**) 11-04-09, 13:38

Thanks.

Basically, SQL 2000 was installed to run an application, but now the vendor has suggested we upgrade to 2008.
The only thing "plugged in" to SQL is the application.
There are no ad hoc queries or anything so I hope it's a straight forward deal.

Smasher · #4 (**permalink**) 11-04-09, 14:36

Can anyone give any advice on if I should Import or Rebuild the full-text catalogs?

Smasher · #5 (**permalink**) 11-06-09, 05:38

Quote:

Originally Posted by muschirhug

A third or fourth breed would result in (I assume) ?

name isDoberman isRottweiler isBoxer isPitBull ?

I think you need to also incorporate a PIVOT in there, else you will have a case every time you have a new breed, unless you dynamically build the case statement based on distinct breeds of dogs (which can be cumbersome).

Are you in the right thread?

Smasher · #6 (**permalink**) 11-11-09, 15:37

I didn't mean to imply that both would be running in tandem, 2008 was placed over 2000.

I patched 2000 up to SP4, ran the Upgrade Advisor which deemed all agreeable.
However, after the upgrade one of the databases was offline.
It appeared healthy in Management Studio, but it had no system properties, no tables, nothing.

Fortunately I had a backup from 5 minutes before the upgrade.
I restored the DB with that backup, 2008 took the restore, and it's been smooth sailing since then.

I hope this information helps anyone with a similar project.

Internet Services

Web Development

Digital Marketing

Consumer Tech