Groups > comp.databases.ms-sqlserver > #1523

Re: Replicate engines between 2008 and 2005 SQL Server

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Replicate engines between 2008 and 2005 SQL Server
Date	2013-07-04 21:35 +0200
Organization	Erland Sommarskog
Message-ID	<XnsA1F3DB9431178Yazorman@127.0.0.1> (permalink)
References	<c90ddcfb-afaf-4ab8-b3b8-8b9f00455b30@googlegroups.com>

Show all headers | View raw

 (parrinha@gmail.com) writes:
> I have a question of replication between servers. Is there anyway to do
> a replica between a Oracle SQL server 2008 and a SQL Server 2005. The
> 2008 server will be the main server and we need to send a copy of the
> data to the 2005 engine. The size of the 2008 DB is near the 800 GB. 

Oracle SQL Server 2008?

Yes, you can set up transactional replication from Microsoft SQL Server 2008 
to Microsoft SQL Server 2005. You should take care that your database does
not use features not supported on SQL 2005.

-- 
Erland Sommarskog, Stockholm, esquel@sommarskog.se

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Replicate engines between 2008 and 2005 SQL Server parrinha@gmail.com - 2013-07-04 10:59 -0700
  Re: Replicate engines between 2008 and 2005 SQL Server Erland Sommarskog <esquel@sommarskog.se> - 2013-07-04 21:35 +0200
    Re: Replicate engines between 2008 and 2005 SQL Server parrinha@gmail.com - 2013-07-04 12:57 -0700

csiph-web