Hi List,
We have the table-based replication of the SQL production database to reporting
server.
Our DBAs require to provide them the T.. H.. and B.. table information along to
the schema name. This works fine for the existing schemas. Replication is the
real-time.
We have issues with the new tables. In some cases we create remedy form only on
the production server, and then a month later getting requirement to add the
same form onto reporting server. Setting the table-based replication is an
issue because after migration that the table's ID on reporting server (T..,H..,
B..) may have the different number.
Yes, the best recommendation would be to migrate the new remedy forms to both
servers at the same time.
Would anybody have the best-practice or the experience recommendation of how to
simplify setting of the replication process (for SQL database). For instance
replicate the remedy system tables ("arschema", fields, forms, etc.)
Thank you,
Mike
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
