如何创建自定义数据迁移查询？ [英] How to create custom data migration query?
问题描述
如果我发布我的mbd的新版本（mde格式）并且用户想要升级他们的b
>他们如何迁移他们的数据？
例如，如果原始版本作为data1.mde发布，然后我发布
data2.mde（相同的表/数据结构 - 只修改了VBA代码，可能是一个
new /更新形式或两个），用户将数据获取到新data2.mde的最佳方式是什么？
我''我想我可以使用查询 - 类似于：
" INSERT [everything] FROM [data1] INTO [data2] EXCEPT WHERE [data1_column] =
AutoNumber"
这意味着我必须以某种方式遍历
数据库中的50个表中的每一个。这是最好的方法吗？其他选择？
提前致谢。
If I release a new version of my mbd (in mde format) and users want to
upgrade - how do they migrate their data?
For example, if the original was released as data1.mde and then I release
data2.mde (same table/data structures - just revised VBA code with perhaps a
new/updated form or two), what''s the best way for users to get their data
into the new data2.mde?
I''m thinking I could use a query - something like:
"INSERT [everything] FROM [data1] INTO [data2] EXCEPT WHERE [data1_column] =
AutoNumber"
This means I would have to iterate through each of the 50 tables in the
database somehow. Is this the best way? Other options?
Thanks in advance.
推荐答案
"杰科" <德** @ hotmail.com>在消息中写道
news：Sw ******************* @ newssvr27.news.prodigy。 com ...
"deko" <de**@hotmail.com> wrote in message
news:Sw*******************@newssvr27.news.prodigy. com...
如果我发布我的mbd的新版本（mde格式）并且用户想要升级 - 他们如何迁移他们的数据？
例如，如果原始版本作为data1.mde发布，然后我发布了
data2.mde（相同的表/数据结构 - 只修改了VBA代码，可能是
a new / updated form或者两个），这是用户将数据传入新data2.mde的最佳方式吗？
我想我可以使用查询 - 例如：
" INSERT [everything] FROM [data1] INTO [data2] EXCEPT WHERE [data1_column]
= AutoNumber"
这意味着我必须遍历50个表中的每个表在某种程度上在
数据库中。这是最好的方法吗？其他选项？
If I release a new version of my mbd (in mde format) and users want to
upgrade - how do they migrate their data?
For example, if the original was released as data1.mde and then I release
data2.mde (same table/data structures - just revised VBA code with perhaps a new/updated form or two), what''s the best way for users to get their data
into the new data2.mde?
I''m thinking I could use a query - something like:
"INSERT [everything] FROM [data1] INTO [data2] EXCEPT WHERE [data1_column] = AutoNumber"
This means I would have to iterate through each of the 50 tables in the
database somehow. Is this the best way? Other options?
您的数据和前端对象应该驻留在单独的文件中，无论是您有一个用户还是30个用户。您当前的问题消失了。
Your data and front end objects should reside in separate files whether
you have a single user or 30 users. Your current problem disappears.
>您的数据和前端对象应位于单独的文件中，无论
> Your data and front end objects should reside in separate files whether
您是单个用户还是30个用户。你当前的问题就消失了。
you have a single user or 30 users. Your current problem disappears.
你的意思是什么？如何将前端对象与数据分开？
我尝试的另一件事是：
新版本（data2）之后是准备好了，删除所有表格和
关系，然后将其变成mde。然后，将所有表格
从data1导入data2。唯一的问题是我无法在新版本中更新或添加
任何新表格，这是非常有限的。
What do you mean? How do I separate front end objects form data?
The other thing I tried was this:
After the new release (data2) is ready to go, delete all the tables and
relationships, and then make it into an mde. Then, import all the tables
from data1 into data2. The only problem with this is I can''t update or add
any new tables in the new release, which is very limiting.
"杰科" <德** @ hotmail.com>在消息中写道
新闻：9W ******************* @ newssvr25.news.prodigy。 com ...
"deko" <de**@hotmail.com> wrote in message
news:9W*******************@newssvr25.news.prodigy. com...
您的数据和前端对象应位于单独的文件中，无论您是单个用户还是30个用户。你当前的问题消失了。
Your data and front end objects should reside in separate files whether
you have a single user or 30 users. Your current problem disappears.
你的意思是什么？如何将前端对象与数据分开？
What do you mean? How do I separate front end objects form data?
Access可以链接到其他文件中的表。你把它带到了极致，并将所有表格设置为另一个文件和presto的链接，一个文件用于数据，
一个文件用于其他所有文件。 />
-
我没有查看此邮件附带的电子邮件帐户
。发送给...
在Hunter dot com的RBrandt
Access can link to tables in other files. You carry this to its extreme and set
up ALL of your tables as links to another file and presto, one file for data and
one file for everything else.
--
I don''t check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
这篇关于如何创建自定义数据迁移查询？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
