Copy Table Data from Sybase to SQL Server
843854Nov 17 2004 — edited Feb 16 2007Hello, 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