replication
Copy a column from a table to another table in SQL Server 2008 R2
All of my tables have a GateCode column which is used for replication purposes. I have a table 开发者_JAVA百科Configuration which has a GateCode column and all tables primary keys are composite of Ga[详细]
2023-04-04 00:18 分类:问答Disable SQL Server replication via command line or batch file, then re-enable
We are using a continuous integration process, and one of the steps for that is to sy开发者_StackOverflow中文版nchronize the databases.For that, we\'ve selected RedGate software that will analyze two[详细]
2023-04-03 11:54 分类:问答mysql replication - master to slave
I have successfully set up a master to slave environment and it is definitely working fine. The only problem I have is that selecting count from a table, they are not the same BUT selecting after 5 m[详细]
2023-04-02 21:37 分类:问答Can I use NOT FOR REPLICATION in Merge Replication with rowguid() field?
I want to use merge replication and I have INDETITY column 开发者_高级运维and I faced with duplicate id number proglem, and I have another field with PK I can\'t use my ID field as PK, I am using SQL[详细]
2023-04-02 19:49 分类:问答How to set up a Staging Environment for Existing Sites? Esp. using subdomains?
I have about 5 sites where till date all development changes have happened directly on the live server, where the change would be made on a test file first and if ok, would replace it with the origina[详细]
2023-04-01 18:33 分类:问答how to keep read and write separate mongo replicat set
bin>mongod --dbpath \"xx\"--port 27017 --replSet replset/127.0.0.1:27018 bin>mongod --dbpath \"yy\"--port 27018 --replSet replset/127.0.0.1:27017[详细]
2023-04-01 16:57 分类:问答CREATE TABLE on MySQL Master that does not replicate to the slaves
I\'ve got bit of script that creates a table on a MySQL master, fil开发者_C百科ls it with data, does some work on the data and then drops the table again.[详细]
2023-04-01 01:42 分类:问答How to best document a replication configuration? [closed]
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing th[详细]
2023-03-31 20:21 分类:问答How to determine if the SQL Server supports replication
I have a UI that needs certain portions to be disabled if the SQL Server it\'s connecting to does not support replication and which types of replication it supports (snapshot, merge, transactional). I[详细]
2023-03-31 19:21 分类:问答Copying tables data between different MySQL Servers
Imagine the s开发者_运维百科etup of 5 myqsl servers and 1 of them has the correct data for some tables which are being updated all the time and I would like to copy over this data to the other mysql s[详细]
2023-03-31 06:24 分类:问答