Results 1 to 6 of 6
  1. #1
    Join Date
    May 2009
    Posts
    14

    Unanswered: SQL Upgrade 2000 to 2008

    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?

  2. #2
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    DTS to SSIS ?
    Unsupported SQL (i.e. old join syntax in where clause vs. ANSI )
    "with" in hints
    etc.

  3. #3
    Join Date
    May 2009
    Posts
    14
    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.

  4. #4
    Join Date
    May 2009
    Posts
    14
    Can anyone give any advice on if I should Import or Rebuild the full-text catalogs?

  5. #5
    Join Date
    May 2009
    Posts
    14
    Quote Originally Posted by muschirhug View Post
    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?

  6. #6
    Join Date
    May 2009
    Posts
    14
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •