Merge databases local and server adp

[Edgar]

Dear all,

I have an Access Data Project application. There is a need to take data
offline.

I use Access 2003. The SQL Server 2000 database is available on the server,
and I have also created a local copy of this database (SQL 2005 express). I
have figured out a way to see if the computer is connected to the db server
or not and then use either the local db or the server db.

Now I want to synchronize the data between the local database and the server
database when the use is online.

What would be the best approach for this? I have looked (almost) everywhere,
but I cannot find a solution.

Can you help me out?

 

[Alex Dybenko]

Hi,
try to look at Replication in SQL Server Books online, perhaps it will work
for you

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Tom van Stiphout]

On Mon, 3 Dec 2007 02:04:01 -0800, Edgar

Check out the "Replication" topic in SQL Server Books Online.

-Tom.

 

[Edgar]

Thanks for your suggestion.

How can I use that functionality from VBA code in Access?

Call a stored procedure, or RMO (does that exist for SQL 2000?) , or...?

 

[Edgar]

Hi,

Yes, I understand that I should use replication, but this is a HUGE subject.

It would be very helpful if someone could help me get started with this.

I do not need fancy stuff. Just merge the whole db from the client with the
server. I do not expect conflicts, and do not need to make exceptions for
tables or columns.

Should I use SQLDMO, RMO, stored procedures, DTS, ???

And a piece of sample code would e very helpful, hopefully some thig nlike:

Dim SS as SQL Server
SS.Connection = "my connection string"
SS.Replicate ("DBname", "LocalServerName", "LocalDBName")

And done...

--
Thanks,

Edgar

Hi,
try to look at Replication in SQL Server Books online, perhaps it will work
for you

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Alex Dybenko]

Hi,
sorry, but this is not so easy, you have to setup replication, etc, etc.

if this is only one-way merge - then you can just make a set or inserts and
put then in a stored proc, that's all

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

Hi,

Yes, I understand that I should use replication, but this is a HUGE
subject.

It would be very helpful if someone could help me get started with this.

I do not need fancy stuff. Just merge the whole db from the client with
the
server. I do not expect conflicts, and do not need to make exceptions for
tables or columns.

Should I use SQLDMO, RMO, stored procedures, DTS, ???

And a piece of sample code would e very helpful, hopefully some thig
nlike:

Dim SS as SQL Server
SS.Connection = "my connection string"
SS.Replicate ("DBname", "LocalServerName", "LocalDBName")

And done...