Hi,
I have to pull data from Production to Reporting server every 30 min.
Which will be the fastest and fastest and fastest way to achieve this
task. I just want to copy data, I have already created all the tables as it
is in reporting sever.
I will run this task as a scheduler.

Thanks

Abhijeet

Two methods

1. A scheduled DTS package
2. Replication

Speed will be much of a muchness I think.

How long does it take to load the data ?

Transactional replication could keep it permanently in sync all - about 5
seconds (In my expereince). This would be nigh on impossible in DTS



--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Abhijeet Raje" <abhijeet2804 (AT) hotmail (DOT) com> wrote

I have choose to go for A scheduled DTS package
BUT What should I use. .. can you provide me some example list ..


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote