Announcement

Collapse
No announcement yet.

How to change compatibility of SQL server 2000 to SQL Server 2005?

Collapse

Unconfigured Ad Widget

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • kilter
    replied
    Re: How to change compatibility of SQL server 2000 to SQL Server 2005?

    The database gets converted as soon as you restore it on a SQL Server 2005 instance.
    The only effects of the compatibility level are:
    * Most new reserved words will not generate an error if used as column or table name (at the cost of not being able to use the new function).
    * Some (not all!) behaviour changes of existing functionality are only active in the newer compatibility level (in case you relied on the old
    behaviour).
    * Some features that have been deprecated for a while already are only available in lower compatibility settings.

    Also, changing the compatibility setting won't enumerate any issues. That's what the upgrade advisor is used for.
    Last edited by kilter; 11-24-2009, 03:09 AM.

    Leave a comment:


  • How to change compatibility of SQL server 2000 to SQL Server 2005?

    Upgrading databases from SQL Server 2000 to SQL Server 2005 using backup and restore method or detach and attach method the compatibility level does not automatically change. Hence, to change the database compatibility, follow below mentioned steps:

    1. Login in SQL Server Management Studio.
    2. Expand database from the left hand side.
    3. Right click on the database.
    4. Click on Properties.



    5. Click on Option tab.
    6. Select SQL Server 2000 (80) from the Compatibility level section as shown in below figure.



    7. Click on Ok button.
Working...
X

Sign up for a News Letter Click here to sign up