migrating from MS Access to SQL Server - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

migrating from MS Access to SQL Server

hello,

I have a VB , Access application(used ADO objects) which I want to migrate MS Access to SQL Server. I want to know whether the Upsize wizard available with Access or DTS Import/Export wizard available with SQL Server is a good tool for doing that. Also, please help me in giving me the steps required in doing that and also things to take care of . thanks for the help.

mahesh

Comments

  • melissa_may1melissa_may1 Posts: 937Member
    : hello,
    :
    : I have a VB , Access application(used ADO objects) which I want to migrate MS Access to SQL Server. I want to know whether the Upsize wizard available with Access or DTS Import/Export wizard available with SQL Server is a good tool for doing that. Also, please help me in giving me the steps required in doing that and also things to take care of . thanks for the help.
    :
    : mahesh
    :

    I haven't used either tool. I usually set up the SQL database, export Access to a text file, and use BCP to input it into SQL.



Sign In or Register to comment.