Post reply

conversion from sqlserver to access

  • July 9, 2006 at 4:31 am

    #173154

    is it possible to convert a database from sqlserver to access(and viceversa) programmatically(i need to do it in java)?

    if it could be simple otherwise i need to convert the .bak file in a .mdb file.

    thanks very very much if you'll help me!!!

  • July 9, 2006 at 2:38 pm

    #648132

    Are you talking about SQL 7.5/2000?

    I used to do something similar using a Data Transformation Services (DTS) package within SQL Server.

    Transfering the queries is a little more involved.

    SELECT, INSERT and DELETE queries work the same way however the UPDATE statement is peculiar to Access. The other thing to consider is that SQL Stored Procedures can carry out multi-operations where as Access queries tend to be single operations.

    A possible alternative is to use MSDE and Access ADP projects. That way you don't have to convert your database.

    LinkedIn Profile

  • July 10, 2006 at 2:12 am

    #648173

    thank you very much.yes, sql2000.

    i don't need to convert queries.

    i only need to convert a simple database (possibly preserving constraints) but whose content is unknown.

    i'll be so grateful if you could give me any other information!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply