0
votes
1answer
48 views

SQL 2008 R2 replication with Oracle DB Server Issue

I am configuring replication between SQL 2008 R2 & Oracle DB server. Getting below error "ORA-01830: date format picture ends before converting entire input string (Source: MSSQL_REPL_ORACLE, ...
0
votes
1answer
49 views

MySQL replication as both master and slave (replication loop?)

I've got two MySQL servers, one as a master in the replication process and the other as the slave. I was wondering if anything bad would happen if I made the current master a slave to the current ...
1
vote
1answer
174 views

How hard is it to setup SQL Replication? Can it be done by a Semi SQL User? [closed]

I'm a semi SQL user, not a DBA, just a regular programmer. One of my upcoming jobs require a SQL replication configuration. I have never done such configuration before My colleagues have been ...
1
vote
2answers
398 views

Distributing SQL Server on Internet regarding security issue

We are going to put our servers in two places to keep high level redundancy and to avoid bandwidth critics. The two servers are on different LANs but communicate over a WAN network (via Internet). One ...
2
votes
1answer
98 views

What options for Windows Server 2008/SQL Server 2008 replication/mirroring across data centres?

Our Microsoft web-application processes around 2000 orders per day. I need to support failover to a secondary data centre. What are the options and experience of implementing a replication/mirroring ...
1
vote
1answer
203 views

Can you use a relatively expensive filter on transactional replication?

I'm trying to replicate (transactional, push) a relatively small table (50K rows), subject to several different filters, which are rather expensive (each taking at least an hour long to complete, ...
1
vote
1answer
69 views

Setup SQL Server replication for schema only or schema + nightly data

We have 2 offices that we would look to keep our databases in sync with. Unfortunately one of our officers has a really poor connection and doing live SQL replication of the data probably isn't ...
0
votes
2answers
340 views

SQL Server Snapshot Replication Subscriber (Editable or Read-Only)

I need to create a copy of my SQL 2008 R2 Enterprise database and have it located on the same server as the original. I will be using this second copy of the database as the target of a mostly ...
1
vote
1answer
148 views

Choosing the right SQL server replication type

This is the scenario: 1 x SQL Server 2000 database running at remote site (Publisher) Website running at a different site requires mostly read and some write access (<5 tables) to the database ...
0
votes
1answer
505 views

Filtering columns in SQL Server replication - how?

I need to replicate some data from two tables in one database to another databases. I used snapshot replication. The issue is that I would like to replicate only some selected columns and the others ...
3
votes
1answer
436 views

Which SQL Server edition?

We need a new install of windows server and sql server to replicate a couple of databases to a geographically separate location from an existing application (over a site-to-site VPN). The source ...
0
votes
4answers
300 views

sql server 2005 Replication

We have a sql server 2005 which contains 4 to 5 databases which are updated everyday externally, Currently we are backing up the Database and attaching to a different server and working on it in order ...
0
votes
2answers
445 views

SQL 2008 Replication corrupt data problem

We took a SQL 2000 database. Took a lightspeed backup. Restored on SQL 2008 active/passive cluster. Then setup replication to replicate the data back to SQL 2000. So 2008 is the publisher/distributor, ...