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:
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
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
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
In my Production Server i have replication which working fine, i do have Distributed Database which as 开发者_JS百科2 subscriber db .
When I run this script to search particular text in sys.columns and I get a lot of \"dbo.syncobj_0x3934443438443332\" like rows.
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
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
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
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.