| Author |
Topic |
|
chih
Posting Yak Master
154 Posts |
 Posted - 2008-05-06 : 01:58:06
|
| Hi everyone,I am not familiar with SQL express. Will it work if I setup publisher/distributor on SQL express and replicate data to exterprise version?Thank you in advance. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-06 : 11:31:56
|
| Yes but SQL express has to subscribers. It's not a good idea to replicate from SQL enterprise to Express. |
 |
|
|
chih
Posting Yak Master
154 Posts |
Posted - 2008-05-06 : 18:40:08
|
As SQL express has to be subscriber, there is no way I can replicate data from express to enterprise.Thanks quote:
Originally posted by sodeep
Yes but SQL express has to subscribers. It's not a good idea to replicate from SQL enterprise to Express.
|
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-06 : 20:41:41
|
| Here is how you do:http://deepakinsql.blogspot.com/2007/10/transactional-replication-in-sql-2005.html |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-06 : 21:58:59
|
| SQL express has to be subscribers in transactional replication. Which type of replication do you like to use? |
|
|
|
chih
Posting Yak Master
154 Posts |
Posted - 2008-05-06 : 22:12:17
|
| transactional replication with push subscription |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-06 : 22:16:58
|
| Then you can't replicate from sql2k5 express to sql2k5 enterprise. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-06 : 22:48:41
|
| In none of the replication ,SQL express works as a publisher |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-06 : 22:59:32
|
| True, but still can replicate from sql2k5 express to sql2k5 enterprise in merge replication. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-06 : 23:05:25
|
| SQL Express works for Transactional and Merge replication but only as a subscriber. check this out Please:http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-06 : 23:11:55
|
| You cannot configure SSE as a Publisher or Distributor for any type of replication. However, SSE can be a Subscriber, and merge replication allows changes to be replicated in both directions between a Publisher and Subscriber. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-06 : 23:46:44
|
| Have to have web synchronizer as there is no SQL server agent in SQl Express. |
|
|
|
|
Replication between SQL sql enterprise and express