Need to write/generate backward compatibility database schema

Question

Hi,I have a database including various stored procedure, functions views, and others.....on sql 2008R2  but situation is such that i need to make an database schema from this database that will support on sql server 2005.

Can i achieve this. How please provide any link or idea reagarding this situation.

Regards

shambhu

Answer 1

I have doubts you can open it in SQL Server 2005 diagram, is that possible to use another tools like MS Visio?

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 2

Script out all objects on SQL Server 2008 using SSMS Object Explorer Script Wizard.

Compile them in order one by one in SQL Server 2005 making the needed changes.

For example, DATE can be replaced with DATETIME data type.

Related article:

http://www.sqlusa.com/sql-server-2008-new-features/

---

Kalman Toth SQL SERVER & BI TRAINING