I am developing an application for one of my customer who has SQL 2005 but I have SQL 2008 on my system. Can I develop my application using SQL 2008 and then ported it simply to SQL 2005? I will use EF and C# for my application and the SQL DB has database (no code).
相关问题
- sql execution latency when assign to a variable
- What is the best way to cache a table from a (SQL)
- php PDO::FETCH_ASSOC doesnt detect select after ba
- Bulk update SQL Server C#
- SQL to Parse a Key-Value String
相关文章
- Entity Framework 4.3.1 failing to create (/open) a
- Code for inserting data into SQL Server database u
- SQL Server 2008 Change Data Capture, who made the
- Delete Every Alternate Row in SQL
- Linux based PHP install connecting to MsSQL Server
- SQL Azure Reset autoincrement
- How do we alias a Sql Server instance name used in
- Is recursion good in SQL Server?
Just install SQL Server 2005 express and use that
At some point, developing an backward compatible app will come back to bite you because there are differences in data types, deprecated features, discontinued features, and behaviour changes. The list is too long to try and remember for development
Short answer: yes.
But there are some differences between SQL 2005 and SQL 2008 databases. You should read up on those to make sure your database is compatible with SQL Server 2005. For example some datatypes only exists in the one version and not the other and so on.