replication

sql server replication - get last synchronization date from query

Does anyone know the query the last synchronization date from sql server (2008). It is the same information displayed in replication monitor, but I want to be able to get that date from a query. ...

Replicate MYSQL data from stage to dev with a script

I have two versions of my application, one "stage" and one "dev." Right now, "stage" is exposed to the real world for beta-testing. From time to time, I want an exact replica of the data to be replicated into the "dev" database. Both databases are on the same hosted Linux machine. Sometimes I create "dummy" data in the development en...

clear sql server replication files

We're doing a full backup of each of our production databases every night. We also have an hour replication occuring during the day to a report database. It looks like the unc share ran out of space today. Is there an automated delete feature for the replication files? Or do I need to manually delete the replication folders that I no...

Can SQL Server Replication include the source dbid in the replicated data?

Let's say I have DatabaseA with TableA, which has these fields: Id, Name. In another database, DatabaseB, I have TableA which has these fields: DatabaseId, Id, Name. Is it possible to setup a replication publication that will send: DatabaseA.dbid, DatabaseA.TableA.Id, DatabaseA.TableA.Name to DatabaseB.TableA? Edit: The reason I'm ...

PostgreSQL replication strategies

Right now we are using PostgreSQL 8.3 (on Linux) as a database backend to our Ruby on Rails web application. Considering that on PostgreSQL database we actively use row level blocking and PL/PGSQL, what can we employ to secure our data -- I mean tools, packages, scripts, strategies -- to successfully replicate the database and build mul...

How to Get Transactional MySQL data into a SQL Server database

I'm working on a project that has a MySQL transactional database backing up a web application. The company uses SQL Server for back office and reporting applications. What is the best way to update SQL Server with the data from MySQL? Right now, we are performing a dump of the MySQL data and doing a full restore. This may not be feas...

MySQL Replication - one website, many servers, different continents

Consider a reasonably large website (2M+ pageviews / m, lots of users) with 2 frontend servers: one front server in the US, and one in Europe. Two dedicated URL bring the visitors on one of the server, one in the french language, the other one in english. Both sites share exactly the same data. What would be the most cost effective solu...

Bi-Directionnal Replication With SQL Server

Hi, Is there a way to make a bi-directionnal Replication with SQL Server ? (BDD 1) Table 1 <=> (BDD 2) Table 1 Thanks. ...

One-way Store and Forward DB Replication Architectural Question

Hi, I am looking for some input please. I am designing a multi-user, mutli-vendor, n-tier database application. Each local installation of this system must replicate its records to a single central server. This server is not directly available to the users of the installed database app and the Internet is the only route to it. The ...

The best technology to synchronize data between different database schemas?

I have an existing SQL Server 2005 database that runs our accounting/inventory application. We are looking at using a new on-line ordering framework - which has it's own database. If we use this new framework, we will need to transfer the on-line ordering data (inventory, prices, orders, customers) - almost realtime - to and from, our ...

SQL Server 2005 Replication Debugging Suggestions

I have a replication setup it was up and running yesterday, now I can't connect to the distributor and I don't know why. The publisher is on a Domain and talks to the subscriber (not on the domain) via VPN. I can ping the publisher from the subscriber and vice-versa. I can log in to MSSQL on the publisher from the subscriber. The publi...

Authenticating a Windows Mobile 6 Device

I have an application that runs on Windows Mobile 6 Professional PDA devices. The application is installed by browsing a url from the device and downloading a cab. Users capture information in the application and this is then replicated back to a SQL 2005 server using merge replication and IIS v6. Although the user needs to log into th...

PostgreSQL availability and merges

Is there a PostgreSQL HA solution that can handle a splitbrain situation gracefully. To elaborate, the system i'm working on is expected to run in several areas with users close to the servers there and connectivity between the zones is known to be questionable. I'd like for the users to be able to continue using the system in a degrad...

SQL Server Replication connection error

After I renamed my PC, I couldn't create new paublications, for database replication in SQL Server 2005. I receive un error "SQL Server replication requires the actual server name to make connection to the server." When I returned my old PC name, the problem solved. How could I make use of replication after renaming the PC? ...

Patterns for replicating user data from one software to another

I have a website that I've integrated with a popular forum software (phpBB). I have it setup so users that login to the main site automatically are logged in to the forum software as well. I do this by authenticating through the forum's API at the very same time. When someone registers for the site, an entry goes in to the main site dat...

SQL Replication - Does simply adding an article cause it to replicate?

I am adding SQL Replication (Transactional, single-publisher/distributor with many subscribers, using SQL 2005) to a website and have searched everywhere in the manual and on Google for this. I am curious -- do I have to actually create a snapshot for new objects to get propagated, or is adding that new object (e.g., table, stored pro...

Is there a tool to help with conflict resolution during MySQL replication?

Hi, Can I find out if there're good tools available for helping with conflict resolution during the replication process? Specifically MySQL. ...

SQL 2005 Transactional Replication: Behavior during snapshot processing?

Hi folks, So, I've got SQL (2005) Transactional Replication generally working well with a single publisher and single (read-only) subscriber. Data changes and updates flow perfectly, with about 5 second latency, which is just fine. My one nagging problem, that I've spent a couple days trying to solve (and Googling everywhere for ans...

What are the scenarios for using mirroring, log shipping, replication and clustering in SQL Server

Hi, As far as i know SQL Server provides 4 techniques for better availability. I think these are the primary usage scenarios, in summary :- 1) Replication would be primarily suited for online-offline data synchronization scenarios (laptop , mobile devices, remote servers). 2) Log shipping could be used to have a failover server with...

Mobile/PDA + SQL Server data synchronization

Hi guys, Need a little advice here. We do some windows mobile development using the .NET Compact framework and SQL CE on the mobile along with a central SQL 2005 database at the customers offices. Currently we synchronize the data using merge replication technology. Lately we've had some annoying problems with synchronization throwin...