Hi, I have a SQL Server 2005 box set up for merge replication to SQL Server CE 3.0. The publication, publisher, distributor and IIS have all been set up. In my application, I attempt to sync the databases using the following code: //TODO: Change for production //*************************** string localDBPath = @"C:\Documents and Sett...
Hi, I am working on a cache replication solution between nodes Node A - master node => Hibernate + Database + Ehcache as secondary cache Node B - regional node=> Ehcache as prmiary cache. no Hibernate Node B is used only as near-by cache for query. Now I am updating data (Say SudentInfo) in Node A, it gets persisted and cached correc...
I want to run the following rename EXECUTE sp_rename N'dbo.Semesters.IsPublic', N'Tmp_ShowNCs', 'COLUMN' I get the error Msg 4928, Level 16, State 1, Procedure sp_rename, Line 547 Cannot alter column 'IsPublic' because it is 'REPLICATED'. Msg 0, Level 20, State 0, Line 0 A severe error occurred on the current command. The results, ...
I have been reading the Paxos paper, the FLP theorem etc. recently and evaluating Apache Zookeeper for a project. I have also been going thru Chubby (Google's distributed locking service) and the various literature on it that is available online. My fundamental usecase for Zookeeper is to implement replication and general coordination fo...
I want to replicate some of data that exists in my database. I want to replicate specified data. Is there a solution? ...
I want to have a version of my db that contains all of data from first to now. If I use sql server replication, can I force that to ignore delete operation for replication? ...
We are looking at hosting our client's data on our own system and using the MS Sync Framework to replicate data with a SQL Server instance on each client's site. Each client might have on average about 500MB of data and there could be up to 1,000 client sites, se we would have about 500GB of data overall. Data changes will need to be rep...
I am working on an application that runs on multiple clients that talk to one main MySQL database. Additionally, we have a web application that uses the same MySQL database. Due to latency issues, all clients will have to run their own local MySQL database which should be a copy of the main MySQL database. The web application remains to...
Say ServerA.TableA is replicated (via Transactional Replication) to ServerB.TableA. If a trigger existed on ServerB.TableA that fired when a row was inserted or updated, would the trigger fire as rows are replicated from ServerA.TableA? ...
I have SQL Server 2005 running on a development machine that is administered by people rather far away, metaphorically speaking. They decided it would be fun to change the Network Name/Computer Name/Hostname in command prompt of this machine from "OldName" to "NewName". SQL Server was installed and distribution and publishing set up un...
Ok, I am just trying to get a place to start here. My sql 2005 publisher with one sql 2000 subscription and one sql 2005 subscription has died. They are trying to rebuild the thing but it is taking too long. I need to synch the two subscribers and make one the publisher(sql 2005 box of course). Isn't there some tables that keep a his...
I have replication set up every thing looks fine I have not errors , but the data is not being moved to the Slave mysql> show slave status \G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: xxxxx Master_User: xxxxxx ...
Hi, I'm trying to configure repication on SQL Server 2005. I can done it using wizard. But when I'm trying to run generated scripts by this wizard the error message appears: Msg 14013, Level 16, State 1, Procedure sp_MSrepl_addpublication, Line 159 This database is not enabled for publication. Msg 18757, Level 16, State 1, Procedure sp...
I'm running replication on a SQL 2008 server. I have a couple of Push Subscriptions. The IP address for one of my subscribers changed. Eg. (10.10.132.16 to 10.10.132.17) Previously I've used sp_changesubscription to change properties like subscriber_login and subscriber_password on the subscription. However the actual subscriber is n...
Hi, I need to make some tests for a potential migration from Mysql to PostgreSql. It will be easier to test if it is possible to use Postgre as slave for my MySQL master. Is it possible ? Thanks in advance ...
I need to add a couple of columns to a table that is a part of a replication set. It is not a constraint coulumn or a part of any article filters and it allows NULL. I have a pretty good idea that I can run this --> ALTER TABLE tblPlanDomain ADD ReportWageES VARCHAR (100) NULL and NOT force all my clients to reinitialize but I was hopin...
I have an J2EE compliant web application. I use a session based token to append a secondary id to all incoming link generated by my application. To prevent my application against CSRF attack, I validate the secondary id before I allow the user session to work off the subsequent page. Recently, while working with session replication mech...
I'm designing a distributed system with a certain flow of data in it. I'd like to guarantee that at least N nodes have almost-current data at any given time. I do not need complete consistency, only eventual consistency (t.i. for any time instant, the current snapshot of data should eventually appear on at least N nodes. It is tricky to ...
Hi! I'm doing a INSERT ... ON DUPLICATE KEY UPDATE but I need the update part to be conditional, only doing the update if some extra condition has changed. However, WHERE is not allowed on this UPDATE. Is there any workaround for this? I can't do combinations of INSERT/UPDATE/SELECT since this needs to work over a replication. ...
I have had an issue with our replication process and would like to salvage some data. I have a process in place where I will connect to each subscriber before flagging them for reinitialization and I will run the below to pull any data they may have entered in during the "dark time". I am pretty sure this will work in a vanilla palace...