Copy of Production DB into Reporting DB on daily basis.

[jvskarthick]

Friends,

I want the copy of Production DB into Reporting DB on daily basis. Considered that production DB is on Machine-A and Reporting DB is on Machine-B. Please give me your valuable suggestion.


Thanks,
JK

[Rabbit]

Set up an integrations package and schedule it to run each day.

[ck9663]

I'd say setup a replication that can run either on demand or end-of-day.

Good Luck!!!


~~ CK