I would like to keep a copy of a 3rd parties code in my SVN repo. (so I can run reports and tests) How could I sync a certain folder / path from their repo into mine? Obviously I can't just do an export from their repo and commit to mine because this would miss deletes. Extra cool points for an automated solution. svn:externals could...
I have merge replication set up between two databases and am using identity ranges on both. I want to add a specific row to a merged table (setting the identity value to something outside of the identity range) on the publisher. When I try this, I get the following error. The insert failed. It conflicted with an identity range check c...
When an InnoDB table is created without a primary key a "hidden" auto inc key is created and used for indexes. Does anyone know if this key is multi-master safe? If setting up auto incs in a database that was to be multi-master the standard mysql approach is to set auto_increment_increment and auto_increment_offset to appropriate values...
We have a couple of SQL Server instances at our main office, and one on our colocated web server. There are a few replications that handle data exchange between the web server and the main office servers. We switched ISPs today at our main office. We did our homework and were ready for the switch (ips in hosts files changed, etc...) ...
Given a typical 3 tiers app deployed at two remote sites. The db behind the two installations contains exactly the same structure and same data. There needs to be a replication mechanism between the two backend db to keep them in synch. The native replication feature of SqlServer would do the job. However, the business layer of the app k...
Hello, I need SQL to be running on 2 data centers(DC) active/active. There are tonnes of challanges to be done here and below are my requirements. Data synchronization must be async. (For higher performance) I need to be able to read/write on both DC When Site1 goes down, all the traffic will be routed to Site2 and when Site1 comes ba...
I have a logging table on the master server that is inserted into very often. I don't need this table replicated to the slave servers, and in fact I already have replicate-ignore-table set on the slaves to ignore it. However, that only happens after all of those inserts are fetched from the master. I'd like to prevent those inserts from...
We are using Replication and seem to be having endless problems with it. It seems to shut down for unknown reasons. It needs to be shut down to remove a column and only starts back up half the time. Does anyone have any advice on how to properly use replication or some alternatives to it. Edit: We are using Sql Server 2005, We cannot ...
I have a SQL 2000 instance that has database with a transactional publication - tables only. It is subscribed to by a SQL 2005 instance - no problems. I need to publish some of the tables from this transactional subscription in a merge publication. Right now, I'm using another database in the SQL 2005 instance as the merge subscriber. ...
I am trying to replicate a database from SQL server 2000 to 2005 they are located on two different servers both running Windows Server 2003 R2. Im am using SERVER1(SQL2000) as the Transactional publisher and distributor and SERVER2(SQL2005) is the subscriber. I can set up the publication and subscription but when I try to syncronize them...
I'm trying to replicate a rather large database from SQLServer 2000 to SQLServer 2008, located on two different servers. I found an article about attempting this and have been trying to follow its direction. Here is the article. Mixed Mode Bi-Directional Transactional Replication between SQL 2000 and SQL 2008 Here is the part I'm s...
Our database architecture consists of two Sql Server 2005 servers each with an instance of the same database structure: one for all reads, and one for all writes. We use transactional replication to keep the read database up-to-date. The two servers are very high-spec indeed (the write server has 32GB of RAM), and are connected via a f...
To preface, I've seen the command to answer this question before, but now I can't find it again, so I'm just looking for the single SQL statement that will solve my problem. I had two publications on a SQL Server 2000 database at one point, but I've since deleted them. However, my log file is growing, and appears to contain unreplicated...
Oracle DataGuard is a technique to replicate data stored in an Oracle RDBMS across several Oracle engine instances. I'm wondering whether DataGuard really provides a linear scalability for a RDBMS. Do you have any experiences with the DataGuard? How does it behave under heavy load conditions? ...
Scenario In our replication scheme we replicate a number of tables, including a photos table that contains binary image data. All other tables replicate as expected, but the photos table does not. I suspect this is because of the larger amount of data in the photos table or perhaps because the image data is a varbinary field. However...
I'm trying to set up transactional pull replication on 2 SQL Server 2005 instances, through a 3rd as a distributor. When the subscription is being initialized, it bulk inserts properly, giving the message that the snapshot was successfully loaded. Then it makes primary key indexes as usual. At this point the job starts over, dropping al...
My application (compact framework) works on Windows CE. The "cold boot" of the device resets the systemtime. Is there any way to synchronize systemtime with Windows Server 2003 (IIS) or using a merge replication on SQL Server 2000. I have a counted column in one of the datatables which counts current time but this row is somehow impossi...
I have a CRUD winform App that uses Merge Replication to allow "disconnected" functionality. My question is; If I am doing all initializing and synchronizing programatically with RMO (like HERE) does it matter if it is a Push or Pull? What would be a difference? I understand the differences between the two (see HERE) but it seems ...
Background Info: File Replication is Lame Currently, we have a massive, high-traffic ASP.NET web application load-balanced across 8 different IIS servers. Due to the nature of the site, minor changes to .aspx files and .ascx controls happen frequently throughout the day, and after being tested and published to live, are replicated out ...
We have several SQL Server 2000 databases (I know, we need to upgrade) that have the same structure and have them set up to replicate to another server. The problem is that whenever I have to change the structure (which is usually pretty easy to do on all databases, especially with tools from Red Gate) I have to stop the replication, ma...