Best Way to Synch 2 Tables?

Patrick A

All,

I have an Access DB. On a nightly basis, I want to look at an Other
DB (not Access, but SQL) and:

+ Add any new records from Other.Clients into Access.Clients

Update 9 fields from Other.Clients into Access.Clients where changes have occured in Other.Clients.

Is this something I should use a "tool" (SQL Data Compare, SqlSync,
etc.) to do, or could I pull this off reliably every night just using
SQL from the query I could construct to do the job from inside my
Access DB?

And for question Deux, if I can just use the SQL I will write, what's
the best way to kick off the process at 3:00 am every morning?

Thanks,

Patrick

Nov 8 '07 #1

Subscribe Post Reply

1507

Erland Sommarskog

Patrick A (pa*****@stradley.com) writes:

And for question Deux, if I can just use the SQL I will write, what's
the best way to kick off the process at 3:00 am every morning?

A scheduled job in SQL Server Agent.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Nov 9 '07 #2

by: steve | last post by:

Hi, I finally figured out the best way to synch local and remote script folders, containing many php script files. What I used to do before was try to ftp all the changed files, etc. which was...

PHP

log shipping - synch

by: tram | last post by:

I have to schedule the automatic restore the standby database for testing backups . The database was already in log shipping mode. Up to what point do I need to restore the database without...

Microsoft SQL Server

Offline synch using XML web-services

by: moko | last post by:

This is a bit long-winded. Can somebody read thru these 2 use cases, and tell me if it is feasible ? :- Use Case : Replication before Offline Synch Scenario 1 : Oracle Server , MSDE client ...

.NET Framework

Best Practice Mysql Tables

by: BPDudeMan | last post by:

Hi There, I've got one table that is constantly being added to (every few seconds). I've got a bunch of users that need to report from this table. What's the best way to setup the tables? ...

MySQL Database

Scope of objects and best practices

by: Rob | last post by:

Rather new to vb.net... I am wondering if the following is possible and sounds reasonable... Can connection objects and datasets be defined once (at program load) and be available for the life...

Visual Basic .NET

How best to keep data set and db in synch

by: Rob | last post by:

I have a form where the user may see a matrix of data in a grid (populated via a dataset). If the user wishes to add a new row of data, they click a button and a new form opens where the user may...

Visual Basic .NET

Synch two heights

by: sfeher | last post by:

Hi All, I am having trouble big times figuring out a way of forcing a DIV to be in synch with another DIV's height in a (mostly vertically) fluid layout in a web app context. The first one has...

Javascript

FTP - Files Synch

by: piggy | last post by:

Hello, I have an application and when a user clicks on it, it first will check to see if the there is a new version in the server using files synch (ftp). If there is then download the new...

C# / C Sharp

C# - Best way to transfer files using Sockets

by: yashg | last post by:

I am building a data backup application in C# using Sockets. It has a server component and a client component. The client is going to upload files to the server through TCP sockets. I've got all...