同步2桌的最佳方式？ [英] Best Way to Synch 2 Tables?
问题描述
全部，
我有一个Access DB。在每晚的基础上，我想看一个其他的
数据库（不是Access，而是SQL）和：
+添加来自其他的任何新记录。客户端进入Access.Clients
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
将Other.Clients中的9个字段更新到Access.Clients中，其中在Other.Clients中发生了更改。
Update 9 fields from Other.Clients into Access.Clients where changes have occured in Other.Clients.
这是我应该使用的工具吗？ （SQL数据比较，SqlSync，
等）要做，或者我可以每天晚上使用
SQL从我可以构造的查询中可靠地实现从我的内部工作
访问数据库？
对于问题Deux，如果我可以使用我将编写的SQL，那是什么
每天早上凌晨3点开始这个过程的最好方法是什么？
谢谢，
Patrick
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
推荐答案
2007年11月8日星期四14:32:15 -0800，Patrick A< pa ***** @ stradley。 com>
写道：
On Thu, 08 Nov 2007 14:32:15 -0800, Patrick A <pa*****@stradley.com>
wrote:
>我有一个Access DB。在每晚的基础上，我想查看其他数据库（不是Access，但是SQL）和：
+将来自Other.Clients的任何新记录添加到Access.Clients
>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
>将Other.Clients中的9个字段更新到Access.Clients中，其中在Other.Clients中发生了更改。
>Update 9 fields from Other.Clients into Access.Clients where changes have occured in Other.Clients.
这是我应该使用的工具吗？ （SQL数据比较，SqlSync，
等）要做，或者我可以每天晚上使用
SQL从我可以构建的查询中可靠地执行此操作从我的内部完成工作
访问DB？
对于问题Deux，如果我可以使用我将编写的SQL，那么每天早上3:00开始启动过程的最佳方法是什么？
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?
是的，这可以在Access中完成（通过运行
查询的宏），虽然某人的PC将会必须在凌晨3点登录
才能实现。一旦设置了这些条件，使用调度程序
在凌晨3:00运行宏。有关打开数据库时如何运行宏的命令行，请参阅命令行的访问帮助。
您也可以在SQL中执行此操作工作，但服务器
将需要MDB所在人员PC的权利。
哪个更好？在不了解您的应用程序和
网络的情况下，我真的不能说。
请将此消息的任何回复发布回新闻组。
有潜伏者谁可以通过我们的交流受益！
Yes, this can be done all in Access (via a macro that runs the
queries), although someone''s PC will have to be logged in at 3:00am
for it to happen. Once those conditions are set up, use Scheduler to
run the macro at 3:00am. See Access Help for the command line on how
to run a macro when the database is opened.
You could also do this all in SQL with a scheduled job, but the server
will need the rights to the person''s PC the MDB is on.
Which is better? without knowing more about your application and the
network, I really can''t say.
Please Post Any Replies To This Message Back To the Newsgroup.
There are "Lurkers" around who can benefit by our exchange!
谢谢，查克。
当你说使用调度程序时，你的意思是Windows任务计划程序，
又名控制面板/添加计划任务？
Patrick
11月10日，下午4:26，Chuck Grimsby< c.grim ... @ worldnet.att.net.invalid>
写道：
Thanks, Chuck.
When you say "use Scheduler", you mean the Windows Task Scheduler,
a.k.a. Control Panel / Add Scheduled Task?
Patrick
On Nov 10, 4:26 pm, Chuck Grimsby <c.grim...@worldnet.att.net.invalid>
wrote:
2007年11月8日星期四14:32:15 -0800，Patrick A< park ... @ stradley.com>
写道：
On Thu, 08 Nov 2007 14:32:15 -0800, Patrick A <park...@stradley.com>
wrote:
我有一个Access DB。在每晚的基础上，我想查看一个其他的
数据库（不是Access，而是SQL）和：
+将来自Other.Clients的任何新记录添加到Access中。客户端
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
将Other.Clients中的9个字段更新到Access.Clients中，其中在Other.Clients中发生了更改。
Update 9 fields from Other.Clients into Access.Clients where changes have occured in Other.Clients.
这是我应该使用的工具吗？ （SQL数据比较，SqlSync，
等）要做，或者我可以每天晚上使用
SQL从我可以构造的查询中可靠地实现从我的内部工作
访问数据库？
对于问题Deux，如果我可以使用我将编写的SQL，那么是什么？
每天凌晨3点开始这个过程的最好方法是什么？
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?
是的，这可以在Access中完成（通过运行
查询的宏），虽然某人的PC将会必须在凌晨3点登录
才能实现。一旦设置了这些条件，使用调度程序
在凌晨3:00运行宏。有关打开数据库时如何运行宏的命令行，请参阅命令行的访问帮助。
您也可以在SQL中执行此操作工作，但服务器
将需要MDB所在人员PC的权利。
哪个更好？在不了解您的应用程序和
网络的情况下，我真的不能说。
请将此消息的任何回复发布回新闻组。
有潜伏者谁可以通过我们的交流受益！
Yes, this can be done all in Access (via a macro that runs the
queries), although someone''s PC will have to be logged in at 3:00am
for it to happen. Once those conditions are set up, use Scheduler to
run the macro at 3:00am. See Access Help for the command line on how
to run a macro when the database is opened.
You could also do this all in SQL with a scheduled job, but the server
will need the rights to the person''s PC the MDB is on.
Which is better? without knowing more about your application and the
network, I really can''t say.
Please Post Any Replies To This Message Back To the Newsgroup.
There are "Lurkers" around who can benefit by our exchange!
>虽然某人的PC必须登录凌晨3点
它会发生。一旦设置了这些条件，使用调度程序
在凌晨3:00运行宏。
>although someone''s PC will have to be logged in at 3:00am
for it to happen. Once those conditions are set up, use Scheduler to
run the macro at 3:00am.
计算机只需要打开，而不是登录Windows任务计划程序
来运行代码。您需要为Scheduler提供名称和密码。
The computer only needs to be on, not logged in for Windows Task Scheduler
to run the code. You will need to supply Scheduler a name and password.
这篇关于同步2桌的最佳方式？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
