I wonder if anyone know/have a good guide for Replication in MS SQL Server 2008? I want to set up a Replication between two different computers that run MS SQL Server 2008, the master runs on Windows Vista, and the slave will run on Windows XP. I´ve done this in earlier days, but between two MySQL-servers. ...
Several days ago i setup some replication for our SQL Server 2005 database, the type of replication was a transactional with updateable subscription. The replication are working fine, lately i test the upgradeable subscription feature by modifying 1 data on subscriber server but then the error was raise and data are not committed. The ...
Is there any connection between error "Failure to write to a message file" and conflicts on Publication side on SQL 2000 server? ...
Suppose a check constraint (involving multiple columns) with the "not for replication" option was added to a database table (e.g. "alter table table_name add constraint constraint_name check not for replication (constraint_expression)") I found syntax for dropping "not for replication" from a column, but not for an existing check constr...
Environment: SQL Server 2005 SP2 (9.0.3077) Transactional Publications (Production and Beta) I have a situation where I have two different Replication Publications setup that use some of the same Articles. Each of these Publications feeds a subscriber on a different machine. One of these shared Articles is a table. At a regular time ...
Hello; This is the scenario: I have a MySQL server with a database, let's call it consolidateddb. This database a consolidation of several tables from various databases I have another MySQL server, with the original databases, these databases are production databases and are updates daily. The company wants to copy each update/insert/...
I have a rails app that uses two of the same models as another rails app I have. What's the best way to keep data synced between two models? MySQL replication probably won't be possible due to hosting restrictions and since stuff that references the replicated data is dependent => :destroy meaning mysql replication will cause stuff tha...
For my current project we are thinking of setting up a dual master replication topology for a geographically separated setup; one db on the us east coast and the other db in japan. I am curious if anyone has tried this and what there experience has been. Also, I am curious what my other options are for solving this problem; we are cons...
We have a particularly bizarre problem; let me set the scene. Solution found see below We have three SQL Server 2005 databases, for the sake of argument called: Alpha, Beta and Gamma. There is a replication relationship defined between these databases as follows: All three databases have a table named "AnExample" with the same schema....
What command would I execute to safely change (i.e. from int to bigint) a replicated column's data type in SQL Server 2005? The column is not a key. There is a non-clustered index on the column. ...
I'm building an intranet web app with an Oracle back end. The Oracle DB will be replicated on another server for reasons that aren't important to this discussion. I'm reasonably certain we'll be using Oracle Basic Replication, not Advanced. Can someone explain to me why most discussions around Primary Keys go something like: Use of ...
I am replicating from MS SQL Server 2005 to a MS SQL Server 2008 (Microsoft CRM Dynamics database). There are a number of views in the source db which no longer have their underlying tables. I have no idea why this is or how it occured. The issue is that the subscriber can't create these views so the subscription keeps failing part wa...
We're having a problem with a merge replication. Our publisher runs SQL Server 2008, while our two subscribers run 2005. Our publisher is trying to send an ALTER TABLE Foo SET (LOCK_ESCALATION) command out to our subscribers. I think I remember reading that this command is new in SQL Server 2008, and if so, it makes sense that the com...
Right now i currently using transactional replication with updatable subscription. Is there any ways (including T-SQL) that can use to shrink down distribution database used within replication schema? The file was named distribution.MDF Also i found quite large data stored on folder repldata, is it save to delete this files? And how? O...
I have a Merge Replication setup between a central server and 200 clients. The vast majority of the clients do not need all 5000 client records. Only the 50 or so that are assigned to them. How would I go about applying a Filter based on who's logged in? Should I create a NEW DB that maps user names to Client Records and go down that...
In continuation to my question How to improve the performance of client server architecture application I have decided to maintain a centralized database and several slave server-database configuration. I plan to use Symmetric DS for replicating between the slave and master database. Each server-database configuration would be installed...
Hi, We have set up a replication scheme master/slave and we've had problems lately because some users wrote directly on the slave instead of the master, making the whole setup inconsistent. To prevent these problems from happening again, we've decided to remove the insert, delete, update, etc... rights from the users accessing the slave...
We are looking at developing a small, simple, Access system for a client using SQL Server Express (2005 or 2008) as database. The only complicating factor is they have two offices and they will need to synchronise some (but not all) data between them. What are my options with the Express edition for doing this? Is there any advantag...
I am currently have a single SQL 2005 server. I would like to replicate to a SQL 2008 Web Edition server. Is it possible to setup replication from a SQL 2005 Standard Edition publisher to a SQL 2008 Web Edition subscriber. What is the best choose for replication type? Are there any major problems with this setup? ...
I need to frequently duplicate one database on my MySQL server to a mirror database on the same MySQL server. I am writing a bash script that makes a mirror of my web application (PHP/MySQL) on a separate subdomain. Users can use this mirror to try out all kinds of crazy things without affecting the production environment. The script is...