Hi, I am developing an application which needs to backup data between SQL Express 2005 and SQL Server 2008. My client runs with an installation of SQL express 2005 and needs to periodically back up data to a server database running on SQL Server 2008. The client db also receives some new data from server and needs to update itself. The ...
I have set up replication for MySql server. I can connect from the slave machine the master server using the replication user/password. I have got the slave sql thread running but the slave i/o thread is not running and the slave i/o status comes as empty when checked using 'show slave status'. What could be the problem ? How to solve th...
Hello, I keep getting the The merge process was unable to create a new generation at the 'Subscriber'. Troubleshoot by restarting the synchronization with verbose history logging and specify an output file to which to write. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200994) Get help: http://help/MSSQL%5FREPL-2147200994 message. ...
I have a scenario where I'm using transactional replication to replicate multiple SQL Server 2005 databases (same instance) into a single remote database (different instance on a separate physical machine). I am then performing some processing on the replicated data for reporting purposes. I'm using table level triggers to identify chan...
We have a client that needs to set up N local databases, each one containing one site's data, and then have a master corporate database containing the union of all N databases. Changes in an individual site database need to be propagated to the master database, and changes in the master database need to be propagated to the appropriate ...
Suppose I have central site and branch sites. Branch sites also have its own distribution center; Northern center, Southern center, Western center, and Eastern center. I would like all information replicate among its own region. But only center site that should have all data in all regions. Data inserted in each region can be updated...
I am just getting started breaking a .NET application and its SQL Server database into two systems - an intranet and a public website. The various database tables will need to be synchronised between the two databases in different ways, for example: Moving from web to intranet, with the intranet data becoming read-only Moving from int...
I have a few columns in a table that are added to my publication articles. When a change on a column that is not included in replication occurs, it still seems to update the msrepl_tran_version which i assume still assigns the row for replication. Is this how SQL-Server works? Is there a way to tell sql only to relicate rows when a colu...
I am developing a web portal in Asp.Net. Primary target users will be of India Only. But in future I may target overseas users also. I want to know if I should use Sql Server Replication or not. Should I concern about "Replication" at initial stage or can I use it at later stages. Thanks in advance. ...
I'm trying to determine if there's a better way to handle replication than the way we're currently doing things. We're essentially trying to determine 2 things: Is there any way to add an existing column from a table to replication without reinitializing the whole publication Can you just select a specific article to reinit...
If I try to duplicate an access file (this file is split into mdb and be mdb, and also has mde files), by importing everything into a brand new access application, why won't the table links work? Everytime I click anything it says that the tables cannot be found Probably so simple its not worth asking on here, but ....??? Thanks! ...
I need to implement a SQL Server replication solution. Very simple need for now. I just need to replicate one pretty simple table from 200 remote sites or so to one central server. The data is not really transactional in nature. I just need it moved up to the central server once a day. I can't decide if I should use push or pull, and I'm...
Hello I have a MySQL database that I replicate from another server. The database contains a table with this columns ID, FileName and FileSize In the table there are more than 4'000'000 records. I want to make fast a search in FileName (varchar) column I found that I can use for this Sphinx search engine. The problem is that I want to...
How do I consolidate multiple publications into 1 consolidated table on the subscriber? For example. Consider a very simple sales model where we replicate sales data from the stores to the central office. Store 1 Sales Table ===================== Item Qty Amt ===================== 111 2 10.00 222 1 ...
I had a auto-increment duplication issue for master-master replication. Then, I set: SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 99999; This skips 9999 queries. Then I did: SHOW SLAVE STATUS\G Slave_IO_Running: Yes Slave_SQL_Running: Yes And it seems to be running OK. But, of course, since I skipped 99999 statements...if I make a change...
I'm currently evaluating possible solutions to the follwing problem: A set of data entries must be synchonized between multiple clients, where each client may only view (or even know about the existence of) a subset of the data. Each client "owns" some of the elements, and the decision who else can read or modify those elements may only...
In an application which embeds SQLite3 and uses an in-memory database, is it possible to replicate the database between two running instances of the application? I could do this by hand with a homebrew protocol duplicating all my DB accesses, but it seems like something that should be done inside the DB layer. ...
I want to lock everything--completely. Very simple. Just prevent things from changing!! Will this work? use mydatabase; flush tables with read lock; ... unlock tables; Edit: But, it has to be available for replication. ...
I intend to use Oracle Streams for replication from Source to Target. The Target will be used mainly to run Reports. Earlier, all the reports used to run on the Source itself. Therefore, this arrangement gives better performance as all report queries are directed to a dedicated Target. I would also like to denormalize the tables on the...
Using Sql Server 2008. Pretend I have a publisher and 2 subscribers A and B. The replicated table has a guid on it and also a primary key that is not the guid. Frequently, updates happen at both subscribers near simultaneously generating 2 different guids but the same primary key. Then when they go to syncronize I get primary key vio...