Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AgaK
Yak Posting Veteran
86 Posts |
 Posted - 2010-11-08 : 22:13:44
|
| HIWould replicating a database from SQL Standard to SQL Enterprise work?Thank youAK |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-11-08 : 22:21:54
|
| yes |
 |
|
|
the_toilet
Starting Member
5 Posts |
Posted - 2011-03-19 : 06:53:38
|
| hi therei love that the answer to this is "yes" but i keep reading that it does not work as a rule... but i am really hoping you can confirm the situations where it is finei have a post on here where i need to replicate between live and reporting server (standard to enterprise) and also the same live server to another server (running standard)are there restrictions to the type of replication or is the standard/enterprise versions irrelevant for certain replication types?i know you can not use mirroring between different classes of SQL server... (though again i have heard you can do it under the hood but it is not supported) |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-03-20 : 10:54:19
|
| I use Transactional and Peer to Peer Replication extensively. I can tell you without question that it works fine between SE and EE.See here as well.Don't know where you read that it doesn't work. It does.What you do need to be aware of is when using different versions, the distributor must be no earlier than the publisher. So if the publisher is 2008, the distributor cannot be 2005. I have several dedicated distributors, and one of 'em is 2005 SE. But the publishers that rely upon it are all EE.But for the 2008 publishers, I use 2008 EE, though I could have used 2008 SE if I wanted.Have a look at this article too. |
|
|
|
the_toilet
Starting Member
5 Posts |
Posted - 2011-03-20 : 15:05:29
|
| thqank you so much for the reply! i can not believe you replied so quick!that is very good news about the replication... i am going to be using 2008 SQL across the board as it is a near green field installationas for the disto server, i wasn't planning on deploying one but i see the logic... and one of the DBs is likely to have tons of read writes so will have to consider it...thank you so much!!! |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-03-20 : 21:30:51
|
| My pleasure. Glad to help. |
|
|
|
|
|
|
replication from standard to enterprise?