Printable View
I have a VB program written with VB 2005 and using SQL express 2005. I just got a new computer and installed VB 2008. It seems the program converted correctly, but I am unable to connect to the database. I assume this is because I no longer have SQL express 2005 installed.
Can I somehow convert the database to work with SQL Compact 3.5?
Greg
Why not just install SQL Express?
In short, it's possible but it may take a little work. SQLCE is a subset of the full SQL, so somethings (like sprocs) are not supported. Also some datatypes may need to be changed.
-tg
So if I install SQL express 2008, is the 2005 database automatically compatible or will I need to convert it from 2005 to 2008? And if so, is this easily done?
compatible - yes.
Will you need to convert it - no. Unless you want to take advantage of additional 2008 features - but I think those are only in the full version of SQL
easily done - yep. Just grab the MDB and LDF files... install 2008, then attach the files. Done.
-tg