replication tool

Is there any tool, commercial, freeware, by MS or something thats easy to
build that does synchronization of a SQL server database with an MA Access
database?
Now the schemas of both these databases are the same. But the data in them
can be added/edited and deleted independently.
Synchronization can happen manually when someone kicks it off. Need not be
real-time.
Thanks!
Girish
Hi Girish,
I have noticed you posted this issue in Newsgroup:
microsoft.public.sqlserver.replication. I will add a reply to that
newsgroup and closely monitor it if you have follow-up questions
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Hi Girish,
I have noticed you posted this issue in Newsgroup:
microsoft.public.sqlserver.replication. I will add a reply to that
newsgroup and closely monitor it if you have follow-up questions
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
sql

Replication Synchronization Error

I have a default full install of the JULY CTP on X86 Windows Server 2003 (fully up to date on the patches). I used the Merge Replication Sample to create the Publisher/Publication. SInce the code sample to create the subscriber doesn't work (apparently some major changes in the assemblies) I had to create the Subscription using the wizard. Both databases are on the same machine (adventureworks and adventureworksreplicated). When I try and sychronize the database the first time I get the following error.

Error loading custom assembly "C:\Program Files\Microsoft SQL Server\100\COM\BusinessLogic.dll", Error : "Could not load file or assembly 'C:\\Program Files\\Microsoft SQL Server\\100\\COM\\BusinessLogic.dll' or one of its dependencies. The given assembly name or codebase was invalid. (Exception from HRESULT: 0x80131047)".

I did confirm that the assembly is there, but do not know what else to look for. The account the synch is running under is the local Administrator (not a good idea I know but just want it to work).

Any ideas?

Thanks

Steve Muise

Neudesic LLC

Two threads down is a workaround for what looks like might be your problem, can you give it a shot? If it doesn't work, then let us know.

Replication of specific records

How replication can be parameterized, let me clear what actually I
want. From publisher side I want specific records synchronization with
subscriber by passing parameter against that parameter publisher will
fetch the records and replicate that records to subscriber. Is it
possible in SQL Server 2000 or SQL Server 2005. If yes then please tell
me how is it possible, it will be appreciated, thanks in advance
regards
Shahzad Tariq
No, you can't dynamically issue parameters against teh replication engine to
control what is synchronized. You can create filters on a publication such
that only a subset of the data is replicated between publisher and
subscriber.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Shahzad Tariq" <stariq@.gmail.com> wrote in message
news:1140447849.852129.291820@.g47g2000cwa.googlegr oups.com...
> How replication can be parameterized, let me clear what actually I
> want. From publisher side I want specific records synchronization with
> subscriber by passing parameter against that parameter publisher will
> fetch the records and replicate that records to subscriber. Is it
> possible in SQL Server 2000 or SQL Server 2005. If yes then please tell
> me how is it possible, it will be appreciated, thanks in advance
> regards
> Shahzad Tariq
>
|||Thanks Michael, it means if I want to transfer specific records from
one database to another by passing parameters I have to write my owner
scripts for that purpose I have to handle transactions as well in those
scripts so that in case any failure it rollback everything. So far I
have already written such kind of script for said purpose,anyway thanks
for your response.
Shahzad Tariq
|||Thanks Michael, it means if I want to transfer specific records from
one database to another by passing parameters I have to write my owner
scripts for that purpose I have to handle transactions as well in those
scripts so that in case any failure it rollback everything. So far I
have already written such kind of script for said purpose,anyway thanks
for your response.
Shahzad Tariq

Replication of specific records

How replication can be parameterized, let me clear what actually I
want. From publisher side I want specific records synchronization with
subscriber by passing parameter against that parameter publisher will
fetch the records and replicate that records to subscriber. Is it
possible in SQL Server 2000 or SQL Server 2005. If yes then please tell
me how is it possible, it will be appreciated, thanks in advance
regards
Shahzad TariqNo, you can't dynamically issue parameters against teh replication engine to
control what is synchronized. You can create filters on a publication such
that only a subset of the data is replicated between publisher and
subscriber.
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Shahzad Tariq" <stariq@.gmail.com> wrote in message
news:1140447849.852129.291820@.g47g2000cwa.googlegroups.com...
> How replication can be parameterized, let me clear what actually I
> want. From publisher side I want specific records synchronization with
> subscriber by passing parameter against that parameter publisher will
> fetch the records and replicate that records to subscriber. Is it
> possible in SQL Server 2000 or SQL Server 2005. If yes then please tell
> me how is it possible, it will be appreciated, thanks in advance
> regards
> Shahzad Tariq
>|||Thanks Michael, it means if I want to transfer specific records from
one database to another by passing parameters I have to write my owner
scripts for that purpose I have to handle transactions as well in those
scripts so that in case any failure it rollback everything. So far I
have already written such kind of script for said purpose,anyway thanks
for your response.
Shahzad Tariq|||Thanks Michael, it means if I want to transfer specific records from
one database to another by passing parameters I have to write my owner
scripts for that purpose I have to handle transactions as well in those
scripts so that in case any failure it rollback everything. So far I
have already written such kind of script for said purpose,anyway thanks
for your response.
Shahzad Tariq

Replication of specific records

How replication can be parameterized, let me clear what actually I
want. From publisher side I want specific records synchronization with
subscriber by passing parameter against that parameter publisher will
fetch the records and replicate that records to subscriber. Is it
possible in SQL Server 2000 or SQL Server 2005. If yes then please tell
me how is it possible, it will be appreciated, thanks in advance
regards
Shahzad TariqNo, you can't dynamically issue parameters against teh replication engine to
control what is synchronized. You can create filters on a publication such
that only a subset of the data is replicated between publisher and
subscriber.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Shahzad Tariq" <stariq@.gmail.com> wrote in message
news:1140447849.852129.291820@.g47g2000cwa.googlegroups.com...
> How replication can be parameterized, let me clear what actually I
> want. From publisher side I want specific records synchronization with
> subscriber by passing parameter against that parameter publisher will
> fetch the records and replicate that records to subscriber. Is it
> possible in SQL Server 2000 or SQL Server 2005. If yes then please tell
> me how is it possible, it will be appreciated, thanks in advance
> regards
> Shahzad Tariq
>|||Thanks Michael, it means if I want to transfer specific records from
one database to another by passing parameters I have to write my owner
scripts for that purpose I have to handle transactions as well in those
scripts so that in case any failure it rollback everything. So far I
have already written such kind of script for said purpose,anyway thanks
for your response.
Shahzad Tariq|||Thanks Michael, it means if I want to transfer specific records from
one database to another by passing parameters I have to write my owner
scripts for that purpose I have to handle transactions as well in those
scripts so that in case any failure it rollback everything. So far I
have already written such kind of script for said purpose,anyway thanks
for your response.
Shahzad Tariq

Replication Monitor Times and Handheld Synchronization times

Hello
When i am Synchronizing(SQL2005 merge replication)
I can see the duration of the Synchronization on the Replication
monitor and i can see that lets say an "initial loading" of the
database with lots of data is taking 4 minutes but on the handheld if i
take the time of the Synchronize() command that can take up to 30
minutes.
Why is this happening? Am I doing something wrong here?
Thanks
Savvas Christodoulou
The replication monitor shows the time it took for the server side
reconciler to write the initial data to the .OUT file in the IIS server.
The writing of the OUT file to the device can take longer depending on your
network connection etc.
<savvaschr@.nodalsoft.com.cy> wrote in message
news:1162307433.787568.183190@.e3g2000cwe.googlegro ups.com...
> Hello
> When i am Synchronizing(SQL2005 merge replication)
> I can see the duration of the Synchronization on the Replication
> monitor and i can see that lets say an "initial loading" of the
> database with lots of data is taking 4 minutes but on the handheld if i
> take the time of the Synchronize() command that can take up to 30
> minutes.
> Why is this happening? Am I doing something wrong here?
> Thanks
> Savvas Christodoulou
>
|||Thanks a lot ,
I finaly understood what was going on just after i post this message.
Regards