October 8, 2012 at 7:09 pm
I have a client I am writing a VB.NET 2010 program. The client is running SQL SERVER 2005. I am using SQL SERVER 2008 EXPRESS.
Will I have a problem with compatibility when I install the sql 2008 database on the clients server rrunningSQL 2005.
As always I thank you.
October 8, 2012 at 8:37 pm
lonhanner (10/8/2012)
I have a client I am writing a VB.NET 2010 program. The client is running SQL SERVER 2005. I am using SQL SERVER 2008 EXPRESS.Will I have a problem with compatibility when I install the sql 2008 database on the clients server rrunningSQL 2005.
As always I thank you.
If you're using the ADO.NET SqlClient then .NET will pick the correct driver for you so do not worry about that. As long as you do not use any of the newer data types in the database or in your code then no, you will not have any issues. I would recommend you change the compatibility mode of the database on your 2008 Express Edition instance to 90 which will ensure your code maintains compatibility with SQL 2005 query syntax. You can do this using the ALTER DATABASE command.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply