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

  • : 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.

Howdy, Stranger!

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

Categories

In this Discussion