SAP SQL Anywhere

Question

What's the use of these strage statements in a reload.sql script for a SQL Remote database:

CREATE PUBLICATION dummy_pub_1( TABLE dbo.RowGenerator )
go
DROP PUBLICATION dummy_pub_1
go

CREATE PUBLICATION dummy_pub_2( TABLE dbo.RowGenerator )
go
DROP PUBLICATION dummy_pub_2
go

CREATE PUBLICATION "dbo"."PUB_ArtTabellen" 
(

Are these dummy publications just created to assure that the real publications have the same publication_ids as in the original database?

Accepted Answer

2

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.

permanent link

answered 22 Sep '10, 13:10

Bruce Hay
2.6k●1●5●10
accept rate: 48%

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?

(22 Sep '10, 13:27) Volker Barth

flat view

SAP SQL Anywhere

What are these "CREATE PUBLICATION dummy_pub_1" statements for?

Follow this question

Related questions