Need to convert MS Access to MS SQL
Hello Dear friend,
Not really necessary. MS SQL already has DTS (Data transformation servers) which allows you to import data from a Access database. It is not perfect and you might well need to check the construct of the tables and indexes but on the whole its not bad.
The second step is to make your application use the MS SQL database rather than the Access database. Changing the database connection will undoubtedly be fairly straight forward but you might also need to alter the sql statement syntax which might prove more challenging.
One thing you might like to try is doing a "Compact and Repair" operation on the Access database. This should really be done on a regular basis otherwise it performance does tend to degrade.
Subject
Written By
Posted
Need to convert MS Access to MS SQL
August 30, 2011 11:39PM
November 11, 2011 11:53AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.