Results 1 to 7 of 7
  1. #1
    TusharSharma is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    May 2019
    Posts
    3

    Question Migrating data from MS Access to Sybase DB


    Hi,
    I have a need to migrate my data from MS Access 2013 to Sybase. Can anyone help me, how should I go about it?

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    sybase is a relational database just like MS access, if you are keeping the same structure of all your tables etc, what exactly is the problem, You should be able to insert your existing data into your sybase tables by either pushing them from the Access side (you would have to have permissions to the sybase tables) or by exporting the data from MS access to text files and importing them on the sybase side. The only thing that may be tricky is the primary key fields or is that the part you're struggling with?

  3. #3
    TusharSharma is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    May 2019
    Posts
    3
    Quote Originally Posted by rpeare View Post
    The only thing that may be tricky is the primary key fields or is that the part you're struggling with?
    Yes, I want to keep the relationships intact. Without breaking anything.

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    That seems to me to be a question for the Sybase folks unless you're implementing something without any external help.

    This:

    http://infocenter.sybase.com/help/in...042629439.html

    seems to indicate if you insert data into a Sybase table, as long as your primary key field is unique, it will be preserved.

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    need to migrate my data from MS Access 2013 to Sybase
    ??? Are you abandoning MS Access completely? OR
    Will you keep Access front end and have Sybase backend??

    What is your experience/understanding of Sybase? ODBC?
    Where does Sybase fit within your organization?
    How well do you know your current MS Access 2013 database? Did you design it? Do you maintain it?
    What exactly is your role in the proposed project?
    There are youtube videos on Sybase and ODBC that may be helpful.

    Just trying to understand your "need".
    Good luck.

  6. #6
    TusharSharma is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    May 2019
    Posts
    3
    Hi, thanks for your response and sorry for the delay in reply
    I am a novice to Sybase and MS Access and have little understanding of ODBC
    The data that we are handling is partially on MS Access and partially on Sybase. The data in MS Access is getting too huge and it is getting slow to work with. That's why it is decided to migrate the database from MS Access to Sybase.
    I have been assigned the task of finding out a way to migrate the data from MS Access to Sybase with keeping the relationships intact.
    I tried searching for a solution by googling first but I didn't find suitable answers, so I posted my question here for the guidance of the experts here.

  7. #7
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I am a novice to Sybase and MS Access and have little understanding of ODBC
    Why were you selected for this project?

    The data that we are handling is partially on MS Access and partially on Sybase.
    Where exactly does Sybase fit into the picture? Who manages/supports Sysbase in your org?

    The data in MS Access is getting too huge
    Please provide some statistics. Do you do Compact and Repair regularly?


    Look at the links at the bottom of this page re Similar Threads for info.

    I recommend that you also review Sybase related forum(s) for info about Sybase.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 08-07-2018, 06:10 AM
  2. Connecting sybase thru ms-access odbc
    By kolokotr in forum Access
    Replies: 1
    Last Post: 08-15-2012, 12:08 PM
  3. Migrating Access
    By teckles in forum Access
    Replies: 2
    Last Post: 09-16-2010, 03:51 PM
  4. Newbie : Need Information on Migrating Data to SQL
    By ebarb in forum Import/Export Data
    Replies: 1
    Last Post: 08-01-2010, 10:03 PM
  5. Connecting sybase thru ms-access odbc
    By murali.kothuru in forum Queries
    Replies: 2
    Last Post: 08-01-2010, 10:00 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums