What's the use of these strage statements in a reload.sql script for a SQL Remote database:
Are these dummy publications just created to assure that the real publications have the same publication_ids as in the original database? asked 21 Sep '10, 16:35 Volker Barth |
Yes, that is exactly the reason. Publication id's can be recorded in the transaction log. Preserving the id's allows logs created prior to the database rebuild to be accessed by SQL Remote without compatibility issues. Otherwise all remote databases would need to be sync'ed before the rebuild (unlikely), or those not synced would need to be re-extracted after the rebuild. answered 22 Sep '10, 13:10 Bruce Hay Well, that's reason enough...thanks for the clarification. I guess the same background applies to the "GRANT CONNECT ... AT n" statements to assure remote users have the same user IDs as before? |