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 |
|
abdul
Starting Member
28 Posts |
 Posted - 2006-09-08 : 04:19:31
|
| Hi everyone,I want to make my computer (using msde) a publisher for transactional replication. Unfortunately msde is not capable of doing that. Do you know any script which will help my computer for functioning as a publisher for transactional replication. Thanksabdul |
|
|
Rishi Maini SQL2K5 Admin
Yak Posting Veteran
80 Posts |
Posted - 2006-09-09 : 09:10:56
|
| Why do you say that "Unfortunately msde is not capable of doing that".Checkout this Article:- --------------------------------------------------------------------http://support.microsoft.com/kb/324992/Managing Distributor and PublisherMSDE 2000 can act as a Publisher and as a Distributor.The steps to create a Distributor and a Publisher in MSDE 2000 are similar to the steps in the regular editions of SQL Server: 1. If the server is registered in SQL Enterprise Manager, you can configure the Distributor and Publisher by using the Replication Wizard. For more information, see the "Replication Wizards" topic in SQL Server 2000 Books Online. 2. If client tools are not available, you can use the OSQL command-line utility and stored procedures, or SQL-DMO to configure the Distributor and the Publisher. ---------------------------------------------------------------So if you do not have the Client Tools on the Box where you are running MSDE, create a Sample Publication for any regular SQL Edition, Script out the Publication and make the necessary changes in the script so that now it points to the MSDE instance and use the OSQL to run that script under the MSDE instance.ThanksRishi Maini |
 |
|
|
abdul
Starting Member
28 Posts |
Posted - 2006-09-11 : 01:52:55
|
| Thanks for your suggestions. I will follow up on these. Hopefully I will achieve making my machine a publisher for transactional replication :) |
|
|
|
Rishi Maini SQL2K5 Admin
Yak Posting Veteran
80 Posts |
Posted - 2006-09-18 : 09:48:52
|
| Abdul a little modification here. My Bad :- I did not noticed that you were asking for transactional piblication. MSDE can't act as Publisher for transactional replication. But for Merge its very much possible:- MSDE 2000 can act as both a Publisher or Distributor, and a Subscriber, and it can replicate between MSDE versions and regular versions of SQL Server. Additionally, you cannot use it for transactional publication, but you can use it as a Publisher of snapshot replication, and merge replication, and as a Subscriber to all three types of publications.ThanksRishi Maini |
|
|
|
|
|
|
|
|
msde as a publisher for transactional replication