Convert SQL 2000 Database to SQL 2005.

TechJunkyTechJunky Member Posts: 881
in Off-Topic
It says to run the mssql2005conversion.sql.script. I cannot find this script anywhere.

Does anyone know how to upgrade a 2000DB to 2005? I cannot get this to work.

Thanks.
· Share on FacebookShare on Twitter

Comments

  • TechJunkyTechJunky Member Posts: 881
    Nm. I was able to figure out a work around...
    · Share on FacebookShare on Twitter
  • jescabjescab Inactive Imported Users Posts: 1,321
    well what was the fix incase we ever need it
    GO STEELERS GO - STEELERS RULE
    · Share on FacebookShare on Twitter
  • blargoeblargoe Member Posts: 4,174 ■■■■■■■■■□
    Is that a script that is included with SQL 2005?

    I believe all you have to to is back it up from the 2000 server and restore it to the 2005 server, and it will do all the necessary conversion.
    IT guy since 12/00

    Recent: 11/2019 - RHCSA (RHEL 7); 2/2019 - Updated VCP to 6.5 (just a few days before VMware discontinued the re-cert policy...)
    Working on: RHCE/Ansible
    Future: Probably continued Red Hat Immersion, Possibly VCAP Design, or maybe a completely different path. Depends on job demands...
    · Share on FacebookShare on Twitter
Sign In or Register to comment.