Our DB is Oracle 10g.
Our Clients Test DB is SQL Server.
Now sometimes, we do incremental loads, full loads or historic load.
The present system what we have is we send the insert statements and the DDL to them and they create and load. I did not write it.
It takes 40 hours.
Under 1 scheme we have 3 or 4 different client tables.
We need to load for client1 only client 1 tables, client2 client2 tables.
This is dependent upon the values in certain cols and it depends upon a join condition.
In Oracle SQL Loader you can do that kind of loading.
Is there a utility/tool that is available in SQL Server with which I can select only certain table rows by joining 3 tables and do a bulk load.
I need to transfer the PK and nothing else.
Data and PK.
Software/Hardware used: Oracle 10g, Sql Server 2008 and Unix windows