database-replication
Synchronizing MS Access database file
I am developing a database with about 10 tables in it. Basically it will be used in 2 or 3 distant geographical locations (let\'s call them A,B and C). The desired work flow will be as follows:[详细]
2023-01-07 01:22 分类:问答Transactional Replication For Write Heavy Medium Sized Database
We have a decent sized, write-heavy database that is about 426 GB (including indexes) and about 300 million rows . We currently collect location data from devices that report to o开发者_开发知识库ur s[详细]
2023-01-06 08:55 分类:问答SQL Server 2005 replication - indicate data is replicated
I am using SQL Server 2005 replication to replicate data from one table on a server开发者_运维技巧 to the a table on a remote server. This is happening in real time. i.e whenever the data is changed a[详细]
2023-01-04 22:01 分类:问答SQL Server 2005 - are stored procedures named sp_MSdel_ related to replication?
I have a server here in my home office setup to receive push subscriptions from a server at our company HQ.I was looking through the li开发者_如何学Pythonst of stored procedures today and see many of[详细]
2023-01-04 15:39 分类:问答Replication SQL SERVER
In my Production Server i have replication which working fine, i do have Distributed Database which as 开发者_JS百科2 subscriber db .[详细]
2023-01-04 00:17 分类:问答What is syncobj in SQL Server
When I run this script to search particular text in sys.columns and I get a lot of \"dbo.syncobj_0x3934443438443332\" like rows.[详细]
2022-12-31 20:52 分类:问答Mysql Master Slave Replication on Large Database table (how to sync initial data)
We have a production server and a dev server. We have found that backups are nearly impossible on the production server because of the query volume we experience. So, we\'re looking at setting up repl[详细]
2022-12-30 00:51 分类:问答Is MySQL Replication Appropriate in this case?
I have a series of databases, each of which is basically standalone.It initially seemed like I needed a replication solution, but the more I researched it, the more it felt like replication was overki[详细]
2022-12-29 12:45 分类:问答Consolidate data from many different databases into one with minimum latency
I have 12 databases totaling roughly 1.0TB, each on a different physical server running SQL 2005 Enterprise - all with the same exact schema. I need to offload this data into a separate single databas[详细]
2022-12-24 06:45 分类:问答Postgresql slave for Mysql Master. Possible?
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.[详细]
2022-12-22 19:12 分类:问答