Converting JET to SQL Database
-
I'm starting a project to convert from a JET databse to an MS SQL database. The application using the data is written in VB 6. On the surface the conversion looks strait forward. Anyone know of any minefields I'm going to run into? Thanks, Nick
I imagine most (if not all) of the SQL in the VB6 app will work just as well with no change on a MS SQL backend. Of course, you will need a new connection string. The OleDb adapters, readers etc should work with MS SQL too. Though you will probably want to change them to SQLAdapters etc. Some saved queries (Access/JET) will need to be converted to MS SQL stored procedures, functions etc. May want to look through the code for any Access/JET automation code that may be used to do things like show reports etc. Other than that, I'd be interested to know what you found myself! Steve