SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    always learning . . .
    Join Date
    Nov 2003
    Location
    UK
    Posts
    821
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Best way to get a SQL 2005 Express database to MsSQL 2000 format

    I have tried a direct backup and restore (.bak file) and this seems to fail as expected. I have also tried a sql script but from local (express) to hosted (sql 2000) there seems ot be too many problems in the script.

    Any tips for transitioning the database as cleanly as possible?

  2. #2
    SitePoint Addict ServerUnion's Avatar
    Join Date
    Jan 2005
    Location
    madison, WI
    Posts
    225
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Make sure your local instance has the compatability set to the lower 2000 version. I would think your migration should work better then.

  3. #3
    always learning . . .
    Join Date
    Nov 2003
    Location
    UK
    Posts
    821
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    How is it I change the compatibility to the lower? Where is the option?

  4. #4
    SitePoint Addict ServerUnion's Avatar
    Join Date
    Jan 2005
    Location
    madison, WI
    Posts
    225
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Through SQL Server Enterprise Manager, right click the database and select properties. select the Options tab and it will be at the bottom named compatibility. Good luck...

  5. #5
    always learning . . .
    Join Date
    Nov 2003
    Location
    UK
    Posts
    821
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Tried it, backed up, restored online but still fails. Shame.....

  6. #6
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,652
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Backing up/restoring is not a "proper" way to deploy a Sql Server database. Nor is shifting between versions. But I digress.

    What you probably need to do is use enterprise manager to generate a Sql script to create the database objects. Data is a stickier issue.


Bookmarks

Posting Permissions

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