Can we revert back to previous compatibility mode???

• klnsuddu

  SSCertifiable

  Points: 5836

  More actions

  April 18, 2009 at 11:07 am

  #136794

  Hi,

  We upgraded from sql server 2000 to sql server 2005.Currently, the compatibility mode is 80. We are planning to change the compatibility to 90 now.

  If something goes wrong after changing the compaibility to 90, can we go back to comatibility 80?

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  April 18, 2009 at 11:13 am

  #980230

  Keep copies of backups in remove able drives because 2000 and 2005 changes sometimes may require many code rewrites depending on the skills of your developers.

  Kind regards,
  Gift Peddie

• maechismo_8514

  SSCoach

  Points: 17510

  More actions

  April 18, 2009 at 11:19 am

  #980232

  klnsuddu (4/18/2009)

  ---

  Hi,

  can we go back to comatibility 80?

  Wouldn't be a good idea though. Lot of hassle later on. Its better to stick to 90 and change your code as needed.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  April 18, 2009 at 11:29 am

  #980233

  klnsuddu (4/18/2009)

  ---

  If something goes wrong after changing the compaibility to 90, can we go back to comatibility 80?

  Yes. The compatibility level just affects how T-SQL is parsed and run and what commands are allowed. Be aware that most new 2005 features do not work in compat mode 80, so if you do any new development and then reduce the compat mode, new stuff may not work.

  If you do, I would suggest you reduce the compat mode just until whatever problems you've found have been fixed, then upgrade it again.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass