Hello all,
I have the following requirement (SQL 2000, SP2)
1. Need to restore production database(A) to another database (B) on
another server (No direct connection)
2. In the restored back-up(B) SP codes should not be visible (even to
sa) or all SP's can be deleted .
3. This needs to be carried out daily
4. New tables may be added frequently to A
5. This job should be scheduled
6. I can overwrite the entire database (B)
7. I can not encrypt SP in the original database (A)
I thought of Snap-shot replication first. But when new tables are
added , I need to add new tables manually to publication .
Can some one suggest most reliable and implementable method ?
Thanks
Srinivas