I would take a full backup of "source" database,

move the dump file to an external disk drive,

ship the external drive to "target" location,

plug the external disk drive on "target"...

Performance of the affected query would be as good or as bad as the performance is in the Oracle database.

Ask you Oracle DBA to do two things for you:

1) Get...

... OR, use SQL Server as a front-end for a database running on Oracle -provided you have deployed Oracle Vault on the back-end Oracle instance 😀

Actually it would be...

Please note Original Poster is refering to TempDB where transactions are minimally logged and...

This is why I love Microsoft's KB... http://support.microsoft.com/kb/823938

Do you have automatic statistics gathering enabled for the offending table?

For veterans is just a conditioned reflex, you know since the old-n-good COBOL times there is a list of “reserved words” you don’t want to mess with. 😀

Starting on SS2K5 all DDL is replicated by default so publisher and subscribers would automatically have identical...

For a distributed transaction the correct syntax is BEGIN DISTRIBUTED TRANSACTION as opposed to BEGIN TRANSACTION.

If no 90 features are needed I would keep it at 80 level -specially if talking about an already stable production environment.

Scenario looks like a text book case of archive & purging where OLTP users access a small database having just NN days worth of data while reporting is conducted against...

You may want to start here... http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html

Prove it.

Allister --

I agree with you provided current table structure is considered a staging area to help dataload -I would certainly get rid of 1-1 relationships on the actual database.

Hope that...

I think it goes a little deeper than that -looking at the columns defined in account-header and account-trailer tables I can see no reason to have account-header and account-trailer data...