|
Home > Archive > SQL Anywhere database replication > January 2006 > Consolidate DB deleted some added rows at remote DB after stop/start subscription
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Consolidate DB deleted some added rows at remote DB after stop/start subscription
|
|
| Veselin Ivanov 2006-01-08, 7:23 am |
| Hi,
using ASA 9.0.2.3198 - one consolidate DB and 5 remote DB. We have to update
all DB - add some new tables, add some new column in exiting tables and
update these columns with defaul values, alter some procedures ...
The steps were :
1. Sinhronize all DB - log_sent and confirm_sent are the same - all data was
sinhronized
2. Stop DBRemote
3. Stop subscription for all remote and consolidate users at all databases
4. Drop subscription for all remote and consolidate users at all databases
5. update all databases - add some new tables, add some new column in
exiting tables and update with defaul values, alter some procedures ...
6. alter publications at all databases
7. create subscription for all users
8. start subscription for all users
9. start DBRemote
After step 9 consolidate DB sent to remote Data Bases commands to delete
some added in last hour rolws in Remote DB !!!
Is it enough to use REMOTE RESET command to start sinhronization at all
databases after last command from update script ?
TIA
Vesselin
--
σΟΞΙΤΑ λΟΞΣΥΜΤ εοοδ
σΟΖΙΡ, 1233, ΥΜ. λΜΟΛΟΤΞΙΓΑ 38
ΤΕΜ/ΖΑΛΣ +359.2.931.54.40
www.siopro.com
office@siopro.com
| |
| Rob Waywell 2006-01-09, 9:23 am |
| Your sequence of steps looks correct. One thing to double check would be
that there are no message files sitting out there in the message system
while you are doing this but I believe you have taken care of this in step
1.
So, if you can reproduce this behaviour then we would like to see it.
Substituting in the REMOTE RESET command at step 8 would be good. The
important benefit of the REMOTE RESET is that is starts all of the
subscriptions for a given user as an atomic operation, rather than having to
start each subscription for a user as a separate operation.
--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional
Sybase's iAnywhere Solutions
Please respond ONLY to newsgroup
EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all
To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288
"Veselin Ivanov" <vs@sonita.com> wrote in message
news:43c0ecc4$1@foru
ms-2-dub...
> Hi,
> using ASA 9.0.2.3198 - one consolidate DB and 5 remote DB. We have to
> update all DB - add some new tables, add some new column in exiting tables
> and update these columns with defaul values, alter some procedures ...
>
> The steps were :
>
> 1. Sinhronize all DB - log_sent and confirm_sent are the same - all data
> was sinhronized
> 2. Stop DBRemote
> 3. Stop subscription for all remote and consolidate users at all databases
> 4. Drop subscription for all remote and consolidate users at all databases
> 5. update all databases - add some new tables, add some new column in
> exiting tables and update with defaul values, alter some procedures ...
> 6. alter publications at all databases
> 7. create subscription for all users
> 8. start subscription for all users
> 9. start DBRemote
>
> After step 9 consolidate DB sent to remote Data Bases commands to delete
> some added in last hour rolws in Remote DB !!!
>
> Is it enough to use REMOTE RESET command to start sinhronization at all
> databases after last command from update script ?
>
> TIA
> Vesselin
>
> --
> σΟΞΙΤΑ λΟΞΣΥΜΤ εοοδ
> σΟΖΙΡ, 1233, ΥΜ. λΜΟΛΟΤΞΙΓΑ 38
> ΤΕΜ/ΖΑΛΣ +359.2.931.54.40
> www.siopro.com
> office@siopro.com
>
|
|
|
|
|