is Replication the answer

[darwin101]

Hi all
We are using sql 2000 standard and want a cheap solution to move reports off of the production(retail transactions) DB to another DB created just for reporting. Staying with the standard edition is Replication the best solution? Any suggestions/pitfalls would be appreciated.
Thanks

 

[SQLDenis]

(almost) realtime or not?
if not just use DTS

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[darwin101]

They would like it to be close to realtime, the stores send information to the main DB server once an hour.
I have never worked with Replication, and limited simple use of DTS. Not real sure where to begin on either.
thanks