Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    21

    Unanswered: real simple n00b question

    How do I or better yet, where do I find info on migrating an Access database to Sybase?

    I have not done this before and I am still very new at all of this anyway, so any basic info would be marvelous.

    O.

  2. #2
    Join Date
    Sep 2002
    Location
    Hong Kong
    Posts
    159

    Re: real simple n00b question

    Sybase have a piece of software called Power Designer. This is data modelling tool and is able to connect to various database platforms - Access included.

    Use Power Designer to reverse engineer your MS Access database into a data model, change the DBMS to Sybase ASA, ASE or ASIQ and regenerate the database schema - Tables, indexes etc.

    Once the database schema has been created, extract the data from MS Access into text files (eg CSV) and use bcp to populate the tables in Sybase.

  3. #3
    Join Date
    Mar 2003
    Posts
    3
    Access has an export feature. export your data to a tab delimited .txt file. then bcp into Sybase. If you have Powerbuilder import the .txt file into Sybase.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •