Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Copy Table Data from Sybase to SQL Server

843854Nov 17 2004 — edited Feb 16 2007
Hello, I was wondering if there is a good way to copy data from a Sybase dataBase to a SQL server using java and JDBC? Both Databases are on different servers so I presume would require different JDBC Connections establish, but how do you go about moving data from one to the other without doing it one by one.

Basically I would like to do something like "Select * INTO SQLServer.Table from Sybase.Table", where both tables have the same schema. Not sure if there is a way to just query one database, get a result set, and just copy the results over to the other database.

Thanks for any help you can provide,

Dan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 16 2007
Added on Nov 17 2004
23 comments
626 views