Convert SQL 2000 Database to SQL 2005.

TechJunkyTechJunky Member Posts: 881
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.

Comments

  • TechJunkyTechJunky Member Posts: 881
    Nm. I was able to figure out a work around...
  • jescabjescab Inactive Imported Users Posts: 1,321
    well what was the fix incase we ever need it
    GO STEELERS GO - STEELERS RULE
  • blargoeblargoe Self-Described Huguenot NC, USAMember 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...
Sign In or Register to comment.