使用DTS迁移Access SQL Server [英] Using DTS to migrate Access ot SQL Server
问题描述
当我尝试从Access导入时，DTS向导只允许我进行
导入表和查询。好吧，我对宏并不感到惊讶。并且
报告不会过来。
但它会执行每个查询，并创建一个_table_来保存结果。
明智的做法是SELECT查询成为视图
而其他查询成为存储过程。但是我找不到
控件我可以选择这样做。
我必须手动创建视图/程序并粘贴到SQL中。 />
然后我仍然需要将它翻译成标准SQL。
-
Wes Groleau
小心努力学习的人，学习它，并发现自己没有比以前更聪明的人......他充满了
杀气腾腾的怨恨那些无知的人没有
来自他们的无知困难。
- Kurt Vonnegut
When I try to import from Access, the DTS wizard only allows me to
import tables and queries. OK, I''m not surprised the "macros" and
reports don''t come over.
But it executes each query, and created a _table_ to hold the results.
The sensible thing would be that SELECT queries become views
and the others become stored procedures. But I find no way
controls I can select to do that.
I have to manually create the views/procedures and paste in the SQL.
And then I still have to translate it into standard SQL.
--
Wes Groleau
Beware of the man who works hard to learn something, learns
it, and finds himself no wiser than before ... He is full of
murderous resentment of people who are ignorant without having
come by their ignorance the hard way.
-- Kurt Vonnegut
推荐答案
Wes Groleau写道：
Wes Groleau wrote:
当我尝试从Access导入时，DTS向导只允许我进行
导入表和查询。好吧，我对宏并不感到惊讶。并且
报告不会过来。
但它会执行每个查询，并创建一个_table_来保存结果。
明智的做法是SELECT查询成为视图
而其他查询成为存储过程。但是我找不到
控件我可以选择这样做。
我必须手动创建视图/程序并粘贴到SQL中。 />
然后我仍然需要将它翻译成标准SQL。
When I try to import from Access, the DTS wizard only allows me to
import tables and queries. OK, I''m not surprised the "macros" and
reports don''t come over.
But it executes each query, and created a _table_ to hold the results.
The sensible thing would be that SELECT queries become views
and the others become stored procedures. But I find no way
controls I can select to do that.
I have to manually create the views/procedures and paste in the SQL.
And then I still have to translate it into standard SQL.
您是否尝试过使用Upsize向导？
Jonathan
Have you tried using the Upsize wizard?
Jonathan
Jonathan Roberts（gr*******@diynics.com）写道：
Jonathan Roberts (gr*******@diynics.com) writes:
Wes Groleau写道：
Wes Groleau wrote:
>当我尝试从Access导入时，DTS向导只允许我导入表和查询。好吧，我对宏并不感到惊讶。并且
报告不会过来。
但它会执行每个查询，并创建一个_table_来保存结果。
明智的事情就是SELECT查询成为视图
，其他查询成为存储过程。但我发现无法控制我可以选择这样做。
我必须手动创建视图/程序并粘贴到SQL中。
然后我仍然需要将其转换为标准SQL。
>When I try to import from Access, the DTS wizard only allows me to
import tables and queries. OK, I''m not surprised the "macros" and
reports don''t come over.
But it executes each query, and created a _table_ to hold the results.
The sensible thing would be that SELECT queries become views
and the others become stored procedures. But I find no way
controls I can select to do that.
I have to manually create the views/procedures and paste in the SQL.
And then I still have to translate it into standard SQL.
您是否尝试过使用Upsize向导？
Have you tried using the Upsize wizard?
我自己从未使用过Access，但是对于那些在Access和SQL Server中拥有
专业知识的人来说，我听到了强烈的建议
远离向导。
从Access迁移到SQL Server是一项艰巨的任务，并且
很多差异。自从Access以来，或多或少是
一体机，而对于SQL Server，您可以获得客户端/服务器设置。
-
Erland Sommarskog，SQL Server MVP， es****@sommarskog.se
SQL Server 2005联机丛书
http://www.microsoft.com/technet/pro...ads/books.mspx
SQL Server 2000联机丛书
< a rel =nofollowhref =http://www.microsoft.com/sql/prodinfo/previousversions/books.mspxtarget =_ blank> http://www.microsoft.com/sql/prodinf .. .ons / books.mspx
I have never worked with Access myself, but from people that hold
expertise in both Access and SQL Server, I have heard strong recommendations
of staying away from the wizard.
Migrating from Access to SQL Server is quite an undertaking, and there
are many differences. Not the least since Access since is more or less
all-in-one, while with SQL Server you get a client/server setup.
--
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
Jonathan Roberts写道：
Jonathan Roberts wrote:
Wes Groleau写道：
Wes Groleau wrote:
>当我尝试从Access导入时，DTS向导只允许我导入表和查询。好吧，我对宏并不感到惊讶。并且
报告不会过来。
[剪报投诉详情]。
>When I try to import from Access, the DTS wizard only allows me to
import tables and queries. OK, I''m not surprised the "macros" and
reports don''t come over.
[snip complaint details].
您是否尝试过使用Upsize向导？
Have you tried using the Upsize wizard?
升迁向导不起作用。在第三个或第四个
页面上，它会弹出一个框，上面只说溢出。
在SQL Server中没有任何反应。
-
Wes Groleau
刘易斯关于上帝存在的理由是谬误的。
"你的意思是循环推理吗？
他相信上帝。因此，他是谬误的。
The upsize Wizard does not work. On the third or fourth
page, it pops up a box saying nothing but "Overflow"
Nothing happens in SQL Server.
--
Wes Groleau
"Lewis''s case for the existence of God is fallacious."
"You mean like circular reasoning?"
"He believes in God. Therefore, he''s fallacious."
这篇关于使用DTS迁移Access SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
