adilsardar wrote: The database contains approx 260 tables and what we need is the data from appox 150 tables. That's over 50%. How much data would that be, in megabytes? And how often will you run this query? adilsardar wrote: Is ssis packages are good solution if we use separate db's and then sych them.? I don't have personal experience with SSIS, but replication sounds good. I are Troll :suss: