How to create a schema in 2008 to support in 2005

Question

Hi, i need to create a database schema in sql2008R2 that should be supported in sql 2005. 

Iny link or idea

Answer 1

Hi,

It must be same as you create schema/database in sql 2005. Make sure you do not use features/objects like latest data types and in-built functions that are not supported in SQL 2005. For moving schema/generate scripts please refer the link below.

http://blog.sqlauthority.com/2009/07/29/sql-server-2008-copy-database-with-data-generate-t-sql-for-inserting-data-from-one-table-to-another-table/

---

Thanks,
Suresh
Please use Mark or Propose as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 2

Set compatibility level to 90.

http://msdn.microsoft.com/en-us/library/bb510680.aspx

---

Serg