If at the moment there is not solution about timestamp,

as written, delete operation (joining equivalent tables) will be prerformed comparing col by col between equivalent tables (apart timestamp col).

Thank for your reply,

I know that timestamp is used only to know if a rw is update, in fact timestamp is the only data not inserted/update (autogenerated by sql server),...

Thank for everybody,

Alzdba solution works.

Hello,

anybody work with Oracle and SQL server 2005 to move data?

Any experiences to help me?

Thank

Openrowset may be interesting, but because of etherogeneous systems and diffrent tables in not applicable.

I need to extract data from some tables in ORACLE that are in structure different from...

I would like to add that Oracle is on HP-Unix server.

Thank any help will be very appreciated.

Thank

thank

very useful for sql 2k5

Thank for useful suggestion

In fact It said about a "the subset" it means only a part of DB, then this is used to reload into original database (ETL).

So there is no way...

I cannot drop FGs because I have to maintain same structure to be spread between RAID for performance

I verified and partial restore do not turn online other tables that do not belong to FG restored (from Microsoft).

So the only thing is to use other technique like DTS...

After lots of researches I found that:

Here it is written that is not possible to load data from a filegroup to a new empty database:

http://support.microsoft.com/?scid=kb%3Ben-us%3B281122&x=10&y=13

I...

I 'll do use DTS o other methods to reach the same goals,

Here it is written that is not possible to load data from a filegrup to a new empty...

Before,

you post it I tried with partial but I have the database offline for objects not belong to the others filegroups.

Any help if possible!