MySQL Forums
Forum List  »  Microsoft SQL Server

Need to convert MS Access to MS SQL
Posted by: Randeep Mann
Date: August 30, 2011 11:39PM

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.

Options: ReplyQuote




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.