Copying many tables from Sybase to SQL Server
Posted: Wed Apr 22, 2009 3:38 am
Hi,
We need to copy many tables (say 50) from Sybase to SQL Server. The tables have IDENTICAL schema. It's just a straight copy across databases.
Do I need to create 50 jobs, or can I have a "template" job with the name of the tables passed in as a parameter?
This would need to support a select * type of approach.
P.S.: I know this isn't a SAS forum, but in SAS it would be SO easy:
Done...
We need to copy many tables (say 50) from Sybase to SQL Server. The tables have IDENTICAL schema. It's just a straight copy across databases.
Do I need to create 50 jobs, or can I have a "template" job with the name of the tables passed in as a parameter?
This would need to support a select * type of approach.
P.S.: I know this isn't a SAS forum, but in SAS it would be SO easy:
Code: Select all
libname in <connection details to sybase>;
libname out <connection details to sql server>;
proc copy in=in out=out;
select desired tables to copy;
run;