replication to sql server by activeX

Hello
i have a an application developed in vb6.0 and back end sql server 2000.
i have a batch file that i created to replicate the data from the sql server
2000 on my pc(local) to replicate on another sql server 2000 which is found
on another machine and the batch file is working fine.
i would like to implement it in my VB application.That is the user will
have a button on the program and on click this will do the replication that
is being done by the batch file for the moment.
i can call the batch file but we would like to do it by activeX.
Is there any activeX that already exist?
how can i do this by using activeX in VB6.0
If you need additional info please let me know..
Thx a lot
Nazeedah
try this:
http://www.indexserverfaq.com/replic...excontrols.zip
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Nazeedah" <Nazeedah@.discussions.microsoft.com> wrote in message
news:53D7A4A9-EBEB-4F76-AF9B-5EF670EBC707@.microsoft.com...
> Hello
> i have a an application developed in vb6.0 and back end sql server 2000.
> i have a batch file that i created to replicate the data from the sql
> server
> 2000 on my pc(local) to replicate on another sql server 2000 which is
> found
> on another machine and the batch file is working fine.
> i would like to implement it in my VB application.That is the user will
> have a button on the program and on click this will do the replication
> that
> is being done by the batch file for the moment.
> i can call the batch file but we would like to do it by activeX.
> Is there any activeX that already exist?
> how can i do this by using activeX in VB6.0
> If you need additional info please let me know..
> Thx a lot
> Nazeedah
>
|||hello
Thank you for the link. its very interesting but i am bit lost in all the
code. could you please tell me which one is more specific in my case
Thank you a lot
"Nazeedah" wrote:

> Hello
> i have a an application developed in vb6.0 and back end sql server 2000.
> i have a batch file that i created to replicate the data from the sql server
> 2000 on my pc(local) to replicate on another sql server 2000 which is found
> on another machine and the batch file is working fine.
> i would like to implement it in my VB application.That is the user will
> have a button on the program and on click this will do the replication that
> is being done by the batch file for the moment.
> i can call the batch file but we would like to do it by activeX.
> Is there any activeX that already exist?
> how can i do this by using activeX in VB6.0
> If you need additional info please let me know..
> Thx a lot
> Nazeedah
>
|||its code sample 5
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Nazeedah" <Nazeedah@.discussions.microsoft.com> wrote in message
news:BEC8AF2F-7EEB-4AF4-B269-7BDF5917BEA7@.microsoft.com...[vbcol=seagreen]
> hello
> Thank you for the link. its very interesting but i am bit lost in all the
> code. could you please tell me which one is more specific in my case
> Thank you a lot
> "Nazeedah" wrote:
sql

Replication solutions?

Hello everybody

I work at a company in Iceland and we have developed a 3-tier solution
written in ASP - Visual Basic - MSSQL2000, 4 companies are using the
solution almost constantly and accessing it through a browser. The
connection has never gone down (yet) so that it has affected our
clients but we are thinking of how be able to run the solution locally
at every place and then create a replication to a main server that is
hosted at our place.

My question is: Does it affect speed for the clients that are using
the solution or is there a better way of doing this?

The solution is a ticket sale system and our clients use it every day
and people that sit at home should be able to order ticket online.
Because of that we can't update the database every 5 minutes or 15
minutes because we don't want a double booking in the same seat.

Any help appreciated!

- Sindri"Sindri Mar" <sindri@.veldi.is> wrote in message
news:8ee9a793.0401090855.774e35cd@.posting.google.c om...
> Hello everybody
> I work at a company in Iceland and we have developed a 3-tier solution
> written in ASP - Visual Basic - MSSQL2000, 4 companies are using the
> solution almost constantly and accessing it through a browser. The
> connection has never gone down (yet) so that it has affected our
> clients but we are thinking of how be able to run the solution locally
> at every place and then create a replication to a main server that is
> hosted at our place.
> My question is: Does it affect speed for the clients that are using
> the solution or is there a better way of doing this?
> The solution is a ticket sale system and our clients use it every day
> and people that sit at home should be able to order ticket online.
> Because of that we can't update the database every 5 minutes or 15
> minutes because we don't want a double booking in the same seat.
> Any help appreciated!
> - Sindri

It's not clear from your description what the reason for considering
multiple local copies is. If the application is web-based, then it shouldn't
really matter where the clients are, assuming they have a good connection to
your web site. Right now you have one database to manage, but creating local
copies would create more administrative work, and replication can become
quite complex. By having one single central database, you should also find
it a lot easier to avoid duplicate bookings, because everyone always sees
the current 'real-time' data.

Having said that, if you have good reasons to consider local copies (such as
copying only a subset of data to the central site, while leaving any
confidential data locally perhaps), then replication can certainly do what
you want. It's a big topic, though, so you may want to post on
microsoft.public.sqlserver.replication to see if you can get some more
detailed advice.

Simon

Replication scripts

Hi,

The company I work for delivers their developed software together with two W2K3 servers using SQL Server 2000. These two servers has two roles, production and backup, and if the production server is offline or if anything happens to it, the backup server becomes the production server. When the original production server is back online, it becomes the backup server.

I have struggled with replication on these two machines. What we would like is to have scripts for these servers. These scripts should be general so that they could be run at both servers. The current production server is setup as distributor and publisher, and the backup server is setup with a pull subscription. Also, when the subscriber is seetup, it should update its database from the publisher

Does anyone have general scripts like this?

Best,
/M

Sorry, it's not clear to me exactly what the problem is. Did you try setting up replication using the wizards? Once it's set up, you can script out the replication scenario in Enterprise Manager.|||

Is replication a part of the solution, or something you need to setup?

Would setting up Database Mirroring between these 2 servers be an option? If do then please refer to http://msdn2.microsoft.com/en-us/library/ms177412.aspx.

This posting is provided AS IS with no warranties, and confers no rights.

Replication Monitor SqlServerCE

I have developed a smart device application using SqlServerCE that replicates data to the backend server. I need to provide to the user a status of this replication process. I read about the "MergeSubscriberMonitor" in SQL Server but can't find it in SqlServerCe. Is this possible? Can someone please point me in the right direction?You need to wait for synchronisation to finish and then you can query to MergeReplication object to report on the data transferred.

If you were using SQLMobile (the CE version for SQL 2005), there is messaging available that will give you progress updates.|||I'm not sure I understand what your comment "messaging" is referring to. Do you have or can point me to some sample code that uses messaging? I am using SQL CE on the mobile device.|||Sorry, by messaging I mean events that you can catch within code and then react to. With SQL CE I don't believe this is happening. You can only query the replication object at the completion of the synchronisation process in order to determine what the outcome was (data sent and received)|||Thanks for your response. I did try asynchronous replication and it is working well so far. I need to implement some additional error trapping but I think I have 95% of what I need. It allows me to get a "percent of completion" during the sync process. I can then display this on the screen to my users. The database is VERY large and was taking forever to sync. I really needed some type of progress bar to show the user. Without that status update, it appeared the unit was locked up. Thanks anyway for your reponse.|||Hi,

I am also trying to get a status update on each article during the web synchronization process. Can you please update me on how to monitor the percent complete progress for the replication.

Thanks in advance.

Apurva

Replication Monitor SqlServerCE

I have developed a smart device application using SqlServerCE that replicates data to the backend server. I need to provide to the user a status of this replication process. I read about the "MergeSubscriberMonitor" in SQL Server but can't find it in SqlServerCe. Is this possible? Can someone please point me in the right direction?You need to wait for synchronisation to finish and then you can query to MergeReplication object to report on the data transferred.

If you were using SQLMobile (the CE version for SQL 2005), there is messaging available that will give you progress updates.|||I'm not sure I understand what your comment "messaging" is referring to. Do you have or can point me to some sample code that uses messaging? I am using SQL CE on the mobile device.|||Sorry, by messaging I mean events that you can catch within code and then react to. With SQL CE I don't believe this is happening. You can only query the replication object at the completion of the synchronisation process in order to determine what the outcome was (data sent and received)|||Thanks for your response. I did try asynchronous replication and it is working well so far. I need to implement some additional error trapping but I think I have 95% of what I need. It allows me to get a "percent of completion" during the sync process. I can then display this on the screen to my users. The database is VERY large and was taking forever to sync. I really needed some type of progress bar to show the user. Without that status update, it appeared the unit was locked up. Thanks anyway for your reponse.|||Hi,

I am also trying to get a status update on each article during the web synchronization process. Can you please update me on how to monitor the percent complete progress for the replication.

Thanks in advance.

Apurva