| Thread | Last Post | Replies |
|
| Can this direction of merge replication be specified? | 31 Mar 2007 18:52 GMT | 1 |
In whatever version of SQL Server 2005, can I make merge or any other type of replication to replicate data only from subscriber to publisher (only upload changes)? -- Thanks, Oskar.
|
| Any problems when table isn't recreated during initialization? | 31 Mar 2007 18:18 GMT | 10 |
I've configured push Merge replication between MS SQL Server 2005 Standard and MS SQL Server 2005 Express. What kind of difficulties will I experience if I don't recreate replicated tables during the reinitialization of subscribers?
|
| Setup Merge Publication from Scratch | 30 Mar 2007 22:50 GMT | 3 |
Just installed SQL Server 2K5 SP1-default install-using local acct-copied new db from another server-configured snapshot and merge agent using impersonate SQL settings ok-ran snapshot ok-ran merge agent and saw this in Monitor details
|
| Subscriber record is missing from subscriber DB | 30 Mar 2007 19:26 GMT | 2 |
SQL Server 2000, merge replication Record created by subscriber on subscriber DB (has ID not in publisher range) exists on publisher but on subscriber. We are using upload and download as a separated in time processes. Subscriber definitely
|
| Merge replication re-initialization | 30 Mar 2007 17:46 GMT | 2 |
I have 2 questions, 1. In what circumstances a subscriber need a re-initialization? 2. When I re initialize the second time, Does it re applies the whole snapshot to the subscriber again or applies only the delta corrections?
|
| replication error | 30 Mar 2007 17:11 GMT | 3 |
we are replicating from SQL 2000 to Oracle via linked server. and are getting the following error "The process encountered invalid column data in bcp file", the bcp file is too big to investigate it, any one has any insight of this?
|
| what is a Merge Conflicts ? | 30 Mar 2007 15:42 GMT | 2 |
How does conflicts happen in merge replication? Whether it is a) rows updated at the SAME TIME at different subscribers? Or b) synchronization is not depend on time but depend on when you
|
| Expiring and Reinitializing Subscriptions | 30 Mar 2007 14:14 GMT | 3 |
Publisher: Windows 2000 SP4 SQL2005 SP1 Subscriber:SQL Server Express Tablet XP SP2
|
| Replication Datawarehousing | 30 Mar 2007 13:42 GMT | 6 |
Can anyone give me a clue as to do DataWarehousing using Replication Publisher/Subscriber? I have 4 Production Database's that I want to replicate to one database acting as a DataWarehouse.
|
| Replicating one table to another table (with different structure) | 30 Mar 2007 13:01 GMT | 1 |
I have 2 databases and plan to user transactional or snapshot replication to replicate data from db1 to db2. db1.table1 name char(20), addr char(500) and db2.table2 has entity char(20), addr1 char(100), addr2 char(100) etc. Table Names & column Names and different but type remain ...
|
| EXACT sequence of events in sync mirroring | 30 Mar 2007 12:45 GMT | 1 |
I need to know exactly the sequence of events in synchronous mirroring mode. What im reading is this: 1. tranaction recved from a client by primary 2. primary writes trans to trans log
|
| Add Index to a Published article | 29 Mar 2007 22:33 GMT | 1 |
How can I add an index to a article in a Merge publication and have that go to the subscribers? Thanks, Steve
|
| Merge replication - schema change. Am I in trouble? | 29 Mar 2007 19:35 GMT | 4 |
after update from 2000SP4 to 2005SP2 I noticed two stored procedures having issue due to changed functionality of the @@IDENTITY vs. SCOPE_INDETITY(). I changed them on the publisher/distributor and regenrated the snapshot before marking subscriptions for reinitialization. Next ...
|
| Programmatic synchronizing and metadata | 29 Mar 2007 19:09 GMT | 1 |
I created a subscription programmatically so I have the CreateSyncAgentByDefaut property = false. Do I have to do some additional functions to work with and clean up the subscription metadata. Thanks for your help.
|
| SQL 2000 Replication error | 29 Mar 2007 17:56 GMT | 3 |
I have a few databases that are replicating over the internet and all but one is working properly. I have a single database that gives the following error: The process could not enumerate deletions at the 'subscriber'. If I manually run the agent it successfully completes, but it ...
|