Publish schema with replication without delete replication (READPAST error)

Document created by schri27 Employee on Jun 6, 2016
Version 1Show Document
  • View in full screen mode

Hello again guys,

 

I found a way to use pdm_publish with BD replication(boxi offline) without delete that replication, only stopping that.

With the replication online, you will recive the READPAST error during the pdm_publish.

 

Before PDM_PUBLISH, you need to stop the replication agent:

replication2.PNG

replication3.PNG

 

With the Agent stopped, insert the var SQL_NO_DIRTY_READS:

sql_dirty1.PNG

 

Now, you can use PDM_PUBLISH without recive the READPAST error.

 

After this, disable that variable:

sql_dirty2.PNG

 

And start the Agent.

 

 

 

Tks to EduardoDiersmann and Sandra_Antunes.

1 person found this helpful

Attachments

    Outcomes