Link to home
Start Free TrialLog in
Avatar of smithmrk
smithmrkFlag for United States of America

asked on

VS2005 .Net2.0 - Can It Connect to a SQL2012 Database?

I currently have several web sites that are all built using VS2005 (.net 2.0) connecting to SQL2005 databases...I was wondering if I updated the SQL Servers to 2012 would the web sites still be able to connect and work as normal?

Thanks,
Mark
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Nothing we require a change (except maybe your connection string to change the server name).
Avatar of smithmrk

ASKER

Just to clarify...just changing the connection string in the Web Config File is all I need to do?

Mark
If it is a web site, you surely have only CRUD statements (Select, Insert, Update, Delete) right?

What was valid for SQL 2005 is still working in SQL 2012.
Normally I just called Stored Procedures for the data...so as long those move over I think based on what your telling me I'm good to go!

Thanks,
Mark
ASKER CERTIFIED SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Yes, that is the plan!

Mark