Transfer of data from Access to Sybase

I just wanted a summary of the steps involved in transferring data from an access database to sybase database. Are there certain issues that one has to be aware of? I am looking for problems, or concern that may arise from this conversion. Thank you,
Hasan
Hasan030800Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
david_levineConnect With a Mentor Commented:
In Access, open the table you want to get into Sybase and click on File / Export. In the window that opens select the location and the name of the exported file and select Text Files in the Save As Type list and then click Save All. Another window will open. Verify that Delimited is checked at the top and click Next. Change the delimiter to Tab and the Text Qualifier to {None}. Click next, verify the location of the file and click the Finish button. You now have a tab-separated file.

In Sybase, create an exact copy of the Access table but use the appropriate Sybase datatypes. Once the table is created, from a DOS command prompt, type something like the following:

bcp db_name..table_name in x:\subdir\flat_file.tab -c -Uuserid -Ppassword -Sserver_name

where db_name is your Sybase database, table_name is the table you created to load the data into, x:\subdir\flat_file.tab is the path and file-name of the exported Access flat file, userid & password are your Sybase id & password and server_name is the Sybase server you are connecting to.

Let me know if you run into any snags.

David
0
 
samphiCommented:
Humm, I'm not sure that:

The field "Memo" on Ms.Access don't function with Sybase.
Convert field Memo to Text before convert your table to Sybase.

Phil.
0
 
david_levineCommented:
Do you need to just do this once or is this an ongoing need?

You can export the table data in Access to a tab delimited flat-file (column separator = Tab and Sting Deliminter = {None}.

The use the Sybase BCP program to load the data.

If this solution sounds viable I can give specifics on each step if you need assistance.

David
0
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 
Hasan030800Author Commented:
Adjusted points to 100
0
 
Hasan030800Author Commented:
David,
Thank you very much for your response. It is a one time thing and I would greatly sppreciate if you could give me some specifics on the steps. Thank you
0
 
Hasan030800Author Commented:
Thank you. I will letb you know if there is a problem (which I do not anticipate).
0
All Courses

From novice to tech pro — start learning today.