Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #1522 > unrolled thread
| Started by | parrinha@gmail.com |
|---|---|
| First post | 2013-07-04 10:59 -0700 |
| Last post | 2013-07-04 12:57 -0700 |
| Articles | 3 — 2 participants |
Back to article view | Back to comp.databases.ms-sqlserver
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
| From | parrinha@gmail.com |
|---|---|
| Date | 2013-07-04 10:59 -0700 |
| Subject | Replicate engines between 2008 and 2005 SQL Server |
| Message-ID | <c90ddcfb-afaf-4ab8-b3b8-8b9f00455b30@googlegroups.com> |
Hi guys, 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. Thanks in advance for your reply. Regards Rodrigo
[toc] | [next] | [standalone]
| From | Erland Sommarskog <esquel@sommarskog.se> |
|---|---|
| Date | 2013-07-04 21:35 +0200 |
| Message-ID | <XnsA1F3DB9431178Yazorman@127.0.0.1> |
| In reply to | #1522 |
(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
[toc] | [prev] | [next] | [standalone]
| From | parrinha@gmail.com |
|---|---|
| Date | 2013-07-04 12:57 -0700 |
| Message-ID | <f1d8eb23-0f7f-4f32-a4b5-7bf2c929c534@googlegroups.com> |
| In reply to | #1523 |
MS SqlServer 2008 :D Thanks Erland, i'll try to do that. Regards El jueves, 4 de julio de 2013 15:35:07 UTC-4, Erland Sommarskog escribió: > (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
[toc] | [prev] | [standalone]
Back to top | Article view | comp.databases.ms-sqlserver
csiph-web