How to configure a Database both, as a Publisher and a Subscriber ?

Hi ,
I am using merge replication wherein we have the following architecture.
We have three different databases. One DB acts as the back office server. The second acts as the desktop DB and the last one is a mobile DB i.e. SQLCE DB.
Data needs to be synchronized between the back office server and the desktop. The SQL CE database connects to the desktop for data synchronization. i.e.
I want to push and pull data from the mobile DB to the desktop DB. Hence, here the Desktop DB acts as the Publisher, and the SQL CE DB acts as subscriber.
Further, the desktop DB needs to push and pull data from the back office DB. Hence, in this case, the Desktop DB acts as the subscriber to the Server, and the back office DB acts as publisher.

Merge replication is not allowing me to make the desktop DB as publisher as well as the subscriber at the same time.

Is there any way we can accomplish this?

Thanks in advance.
Regards,
Pushkar.Hi,

Open the SQL Enterprise manager and select the distributor SQL server.
Select the replication option in the tools menu.
Select the option Configure publishers, subscribers and distributors.

Remember to declare all the involved SQL servers on the Distributor (!) via the Client Network Utility (a small program which is installed together with SQL server)

Success, VincentJS

how to compare what has been changed between yesterday and today

Hello
1/ I am looking for ways to find out what has been changed per each table.
2/ Everyday I have a full database back up bak file created - about 10G.
(about 400 tables)
3/ Every day I will do a full restore of the day before yesterday database
and yesterday database.
e.g. Name of databases: DayBeforeYestDB,yesterdayDB
4/ Question:
Any tools to generate created another database that will contain only the
list of tables with data changed.
or
do I have to write my own scripts
Regards
it com
www.red-gate.com
SQL Data Compare...best $295 you will ever spend...
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"itcom" <jensonluk1@.netscape.net> wrote in message
news:B5163A1E-880F-4437-AE2C-AFACA43949CD@.microsoft.com...
> Hello
> 1/ I am looking for ways to find out what has been changed per each table.
> 2/ Everyday I have a full database back up bak file created - about 10G.
> (about 400 tables)
> 3/ Every day I will do a full restore of the day before yesterday database
> and yesterday database.
> e.g. Name of databases: DayBeforeYestDB,yesterdayDB
> 4/ Question:
> Any tools to generate created another database that will contain only the
> list of tables with data changed.
> or
> do I have to write my own scripts
>
> Regards
> --
> it com
|||Hi,
What actually u need to know .If i understand ur Ques. u want that what
data chnages took place between last 2 backups.
Red-gate is good it will set a auditing option so will come to know
what datachanges and in which table.
Otherwise u can write ur on script.
U can restore both the database and compare the record count.
Or enable a C2 Auditing mode.
from
Doller

how to compare what has been changed between yesterday and today

Hello
1/ I am looking for ways to find out what has been changed per each table.
2/ Everyday I have a full database back up bak file created - about 10G.
(about 400 tables)
3/ Every day I will do a full restore of the day before yesterday database
and yesterday database.
e.g. Name of databases: DayBeforeYestDB,yesterdayDB
4/ Question:
Any tools to generate created another database that will contain only the
list of tables with data changed.
or
do I have to write my own scripts
Regards
it comwww.red-gate.com
SQL Data Compare...best $295 you will ever spend...
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"itcom" <jensonluk1@.netscape.net> wrote in message
news:B5163A1E-880F-4437-AE2C-AFACA43949CD@.microsoft.com...
> Hello
> 1/ I am looking for ways to find out what has been changed per each table.
> 2/ Everyday I have a full database back up bak file created - about 10G.
> (about 400 tables)
> 3/ Every day I will do a full restore of the day before yesterday database
> and yesterday database.
> e.g. Name of databases: DayBeforeYestDB,yesterdayDB
> 4/ Question:
> Any tools to generate created another database that will contain only the
> list of tables with data changed.
> or
> do I have to write my own scripts
>
> Regards
> --
> it com|||Hi,
What actually u need to know .If i understand ur Ques. u want that what
data chnages took place between last 2 backups.
Red-gate is good it will set a auditing option so will come to know
what datachanges and in which table.
Otherwise u can write ur on script.
U can restore both the database and compare the record count.
Or enable a C2 Auditing mode.
from
Doller

how to compare what has been changed between yesterday and today

Hello
1/ I am looking for ways to find out what has been changed per each table.
2/ Everyday I have a full database back up bak file created - about 10G.
(about 400 tables)
3/ Every day I will do a full restore of the day before yesterday database
and yesterday database.
e.g. Name of databases: DayBeforeYestDB,yesterdayDB
4/ Question:
Any tools to generate created another database that will contain only the
list of tables with data changed.
or
do I have to write my own scripts
Regards
--
it comwww.red-gate.com
SQL Data Compare...best $295 you will ever spend...
--
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"itcom" <jensonluk1@.netscape.net> wrote in message
news:B5163A1E-880F-4437-AE2C-AFACA43949CD@.microsoft.com...
> Hello
> 1/ I am looking for ways to find out what has been changed per each table.
> 2/ Everyday I have a full database back up bak file created - about 10G.
> (about 400 tables)
> 3/ Every day I will do a full restore of the day before yesterday database
> and yesterday database.
> e.g. Name of databases: DayBeforeYestDB,yesterdayDB
> 4/ Question:
> Any tools to generate created another database that will contain only the
> list of tables with data changed.
> or
> do I have to write my own scripts
>
> Regards
> --
> it com|||Hi,
What actually u need to know .If i understand ur Ques. u want that what
data chnages took place between last 2 backups.
Red-gate is good it will set a auditing option so will come to know
what datachanges and in which table.
Otherwise u can write ur on script.
U can restore both the database and compare the record count.
Or enable a C2 Auditing mode.
from
Doller

How to color alternate row ?

Hey all...
I would like to apply back ground color to alternate row so is it possible ?? how ?
ThanksSection expert, color tab, click background color formula box and enter something like

if recordnumber mod 2 = 0 then crSilver else crNoColor|||Thank you very much JaganEllis...

It works for me ...|||But when I export my report in excel sheet it gives me file without background color so how can I get same background color if I export my report in EXCEL?

Thanks|||How are you doing the export?
I believe you can choose to export just the data, or the formatting too.
Certainly works OK for me when I choose File.Export.Export Report and choose the format as the non Data only Excel option, to the application.|||I am exporting manually and what I am doing in crystal report is after previewing my report I go to File menu -> Print -> Export

And to export in Excel I have 2 options to choose from so first one Excel 8.0 (XLS) and 2nd one is Excel 8.0 (XLS) (Extended)

But in none of them I am able to export format too..|||Did you select Data only option? Dont Choose that option