How To Mimic Replmerg.exe In Vb.net
Dec 20, 2005
Hello,
On an existing Merge Pull Subscription (Subscriber: SQL Express) via websync how can we start replication via vb.net? We can use the cmd line replmerge.exe and all works fine however we would like this to be cleaner as it's going to be on demand sync. I saw in BOL about the RMO and how to create pubs/subs but nothing telling me how to actually start the replication process. Is there a sample of how to start the replication process in vb.net for websync? Thanks in advance.
John
View 17 Replies
Feb 14, 2005
:eek:
OK, I'm having fun here. I have 3 anonymous subscribers using merge replication all, including the server, on SQL 2000 Server SP3a.
2 of the 3 subscribers crash during the merge process, a Dr Watson error log comes up saying that the replmerg.exe has died.
I have checked for orphaned processes of the same name to no avail. Just in case I made a mistake, I rebooted the server to ensure that any orhpaned processes were killed. No Joy.
Does anyone have any idea what this would happen?
View 2 Replies
View Related
Nov 22, 2006
How do you do! The Question of such plan There is server SQL Server 2005 Standard Edition and SQL Server Express, Between them is adjusted replication merge, on request pull, through web, on https. Podpischik in this instance SQL Server Express. So has here is noticed such particularity that when do synchronizing through Windows Synchronize manually, all pass fine, repeat same actions by means of being included in express utilities merge.exe? all ok. only when on publisher appears new articles, utility merge.exe refuses his(its) tighten appears the mistake:
2006-11-22 10:18:22.593 OLE DB Subscriber 'TERM0701SQLEXPRESS': sp_MSacquiresnapshotdeliverysessionlock2006-11-22 10:18:22.609 OLE DB Subscriber 'TERM0701SQLEXPRESS': sp_MStrypurgingoldsnapshotdeliveryprogress2006-11-22 10:18:22.625 OLE DB Subscriber 'TERM0701SQLEXPRESS': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}2006-11-22 10:18:22.656 Percent Complete: 02006-11-22 10:18:22.656 Snapshot will be applied from the alternate folder '\ReplSnapshotGAIuncREPL_TEST8_TEST820061122123965'2006-11-22 10:18:22.656 OLE DB Subscriber 'TERM0701SQLEXPRESS': sp_MSissnapshotitemapplied @snapshot_session_token = N'\replSnapshotGAIuncREPL_TEST8_TEST820061122123965', @snapshot_progress_token = N'\replSnapshotGAIuncREPL_TEST8_TEST820061122123965Table_2_21.sch'2006-11-22 10:18:29.468 OLE DB Subscriber 'TERM0701SQLEXPRESS': sp_MSreleasesnapshotdeliverysessionlock2006-11-22 10:18:29.484 The schema script 'Table_2_21.sch' could not be propagated to the subscriber.2006-11-22 10:18:29.500 OLE DB Subscriber 'TERM0701SQLEXPRESS': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}2006-11-22 10:18:29.531 Percent Complete: 02006-11-22 10:18:29.531 The schema script 'Table_2_21.sch' could not be propagated to the subscriber.2006-11-22 10:18:29.531 Percent Complete: 02006-11-22 10:18:29.531 Category:NULLSource: Merge Replication ProviderNumber: -2147201001Message: The schema script 'Table_2_21.sch' could not be propagated to the subscriber.2006-11-22 10:18:29.546 Percent Complete: 02006-11-22 10:18:29.546 Category:AGENTSource: TERM0701SQLEXPRESSNumber: 20143Message: The process could not read file '\ReplSnapshotGAIuncREPL_TEST8_TEST820061122123965Table_2_21.sch' due to OS error 1326.2006-11-22 10:18:29.546 Disconnecting from OLE DB Subscriber 'TERM0701SQLEXPRESS'2006-11-22 10:18:29.546 Disconnecting from OLE DB Subscriber 'TERM0701SQLEXPRESS'2006-11-22 10:18:29.562 Disconnecting from OLE DB Subscriber 'TERM0701SQLEXPRESS'2006-11-22 10:18:29.562 Disconnecting from OLE DB Subscriber 'TERM0701SQLEXPRESS'
Then and there start Windows Synchronize with the same parameter and all ok! New Article unrolled hereon not changing adjustment start the utility merge.exe? and mistakes no, forms such impression that utility merge.exe tightens only changes to data, or I have wrong exposed all keys under her(its) start, example of my calling the utility:
replmerg-Publisher Repl-PublisherDB Gai-Subscriber TERM0701SQLEXPRESS-SubscriberDB Gai-Publication ReplGAI-ValidateInterval 5-SubscriptionType 1-PublisherSecurityMode 0-PublisherLogin sa-PublisherPassword 111-SubscriberSecurityMode 0-SubscriberLogin sa-SubscriberPassword 111-SubscriberType 0-Distributor Repl -DistributorSecurityMode 0-DistributorLogin sa-DistributorPassword 111-FileTransferType 0-ExchangeType 3-AltSnapshotFolder \ReplSnapshotGAI-Output c:ErrorRepl.txt-LoginTimeout 30-InternetURL https://Repl/gai/replisapi.dll-InternetLogin ReplUserTerm -InternetPassword qwerty@123
that can be a mistake? rights on execution replication beside replmerg.exe and beside Windows Synchronize alike
View 1 Replies
View Related
Mar 23, 2007
Hello,
I tried to use REPLMERG utility for Web synchronization and got the following error message in log file:
2007-03-23 14:35:10.484 The subscription to publication 'X' could not be verified. Ensure that all Merge Agent command line parameters are specified correctly and that the subscription is correctly configured. If the Publisher no longer has information about this subscription, drop and recreate the subscription.
The case description is as the following:
REPLMERG utility command line:
"C:Program FilesMicrosoft SQL Server90COMREPLMERG.EXE" -ExchangeType 3 -Publication X -
Publisher B01 -Subscriber 127.0.0.1SQLEXPRESS -Distributor B01 -PublisherDB DBS -
SubscriberDB DBS -PublisherSecurityMode 1 -Output C:TempDBS.log -OutputVerboseLevel 2 -
SubscriberSecurityMode 0 -SubscriberLogin Operator -SubscriberPassword XXX -
SubscriptionType 2 -DistributorSecurityMode 1 -Validate 3 -InternetURL
https://www.company.com/Synch/replisapi.dll -InternetSecurityMode 0 -InternetLogin USER1 -
InternetPassword PWD1 -SubscriberType 0
The subscription to the publication X has been created with the following T-SQL script:
USE DBS
EXEC sp_addmergepullsubscription
@publisher = N'B01',
@publication = N'X',
@publisher_db = N'DBS',
@subscriber_type = N'anonymous',
@sync_type = N'automatic',
@subscription_priority = 0.0;
I've also tried to check subscription information on the server 127.0.0.1SQLEXPRESS using the following:
sp_helpsubscription_properties N'B01', N'DBS', N'X'
but the result set is empty. When I run sp_helpsubscription_properties
I get the same empty result. But the subcription is anonymous and when I synchronize it using RMO - it works.
Could you please advice what could cause the problem?
Thank you.
Alexander.
View 16 Replies
View Related
Sep 28, 2000
Recently, we had some tables inadvertantly dropped from a 20+ GB data warehouse in the middle of one of our load cycles. In order to avoid restarting the load, we had to make restore a copy of the database from a full database backup and then manually move in the dropped tables using DTS.
This ended up being a painful process, and I am looking to avoid it by restructuring the database into filegroups so I can mimic the table restore function from 6.5.
I am looking for pros, cons, gotchas, and best practices regarding splitting a MSSQL 7 database into multiple filegroups. We would be including 1 or more tables and all of thier indexes in each filegroup. Specifically, I have the following questions:
1. All the literature I read mentions the need for doing transaction log backups and restores if I utilize filegroup backups. Is this really necessary? We have turned off transaction logging for performance reasons, and since we completely control the addition of new data into the db.
2. Are there implications for disk read performance involved with filegroups? Our data resides on an EMC disk array. I feel that we'll most likely have between 20 and 30 filegroups.
3. If we decide to move a table (and its indexes) between filegroups, is the process as simple a dropping the clustered index and recreating it on the new filegroup (then dropping and recreating the n-c indexes)?
Any information y'all can post would be greatly appreciated.
View 1 Replies
View Related
Oct 19, 2006
Does anyone know how to do the following. I'm trying to mimicreplication with triggers.I have 2 databases, each have these 2 tables.1.USERSID intNAME varchar(20)2.CHANGESTABLE varchar(20)TYPE varchar(10)col1 varchar(20)col2 varchar(20)On the USERS table I have a for insert trigger. Whenever a new user isadded the trigger puts an entry into the CHANGES table such as("USERS", "INSERT", "1", "Fred")I now have an application (vb.net) that monitors the CHANGES table onserver1. If it finds an entry it determines the table using the TABLEcolumn and performs the necessary insert and deletes the entry fromCHANGES. Now the problem is server2 also has an for insert trigger onthe USERS table so it puts an entry into CHANGES on server2. As youcan imagine this goes around in a loop.What I was hoping for was someway of saying, "I'm inserting from myapplication so don't do the trigger".Any ideas gratefully appreciated.Steve.
View 9 Replies
View Related
Jul 24, 2007
I'm trying to mimic the rowcount transform's custom property called VariableName in a custom pipeline transform, with the same drop-down and list of variables in the default property grid as that of "RowCount".
Should a UITypeEditor or a TypeConverter be used for such a custom property? More importantly, in either case, how do you get from the UITypeEditor or TypeConverter to the TaskHost which contains the Variables to enumerate?
I'm not that familiar with Windows Forms, but it appears in both cases (editor or type converter), an ITypeDescriptorContext parameter named "context" is passed, but I'm certain how to get from A to B, that is, from the context variable to the TaskHost.
P.S. There's no need to add a new variable, just select from those that already exist.
View 5 Replies
View Related
May 31, 2006
Hi Guys,
The way I understand a Data Flow Task is that it inserts the rows from the source to destination one by one. Is there a way to make it act like a bulk insert task? We have been experiencing performance issues when inserting a lot of rows from one table to another. If there's no way to actually do it, can a bulk insert task functionality be scripted? Coz what I need is a table to table insert, and the bulk insert task only accepts data files as sources.
Thanks!
Kervy
View 8 Replies
View Related
