将 SQL Server 2000 升级到 2005 或 2008 - DTS 到 SSIS
我们的办公室使用 SQL Server 2000，总的来说它很好地满足了我们的需求。 我正在考虑升级到 SQL 2005 或 2008 的可能性，因为 2000 年没有发现新功能（当我看到索引使用统计信息，它告诉我哪些索引最常用，哪些索引从未使用过，这让我大吃一惊） 。
我不太关心如何将数据库从 2000 年移动到 2005 年或 2008 年 - 我可以只进行完整备份，然后将备份恢复到新的 sql 安装。 我关心的是现有的 DTS 包。 我们每天都依赖数十个它们。 将现有 DTS 包转换为 SSIS 有多困难/容易？ 我必须注意哪些“陷阱”？
Our office uses SQL Server 2000, and by and large it has served our needs well. I'm looking into the possibility of upgrading to SQL 2005 or 2008 because of the new features not found in 2000 (when I saw Index usage statistics which told me which Indexes were the most used and which were never used, that blew me away).
I'm not too concerned with how to move the databases from 2000 to 2005 or 2008 - I can just take a full backup and then restore the backup to the new sql installation. What concerns me are the existing DTS packages. We have dozens of them that we rely on every day. How difficult/easy is it to convert the existing DTS packages to SSIS? What are some of the 'gotchas' that I have to look out for?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
进行备份& 恢复进行数据库服务器升级有很多问题。 最好进行就地升级（您可能需要首先对服务器进行完整备份）& 让 MS 安装程序来完成工作。
2005 支持 2000 个 DTS 包作为旧版本，因此无需学习 SSIS 和 DTS 包。 转换您的所有包裹，除非您有时间和时间 没有太多。
至于备份& 恢复升级，不要忘记：
有关详细信息，请参阅 KB246133
到系统数据库将需要
需要重新创建或转移
需要重新创建
重新设置& 备用服务器也
升级版
Doing a backup & restore to do a database server upgrade has many gotcha's. It's best to do an in-place upgrade (you might want to take a full backup of the server first) & let the MS installer do the work.
2005 supports 2000 DTS packages as Legacy so there's no need to learn SSIS & convert all your packages unless you have the time & there isn't too many.
As for the backup & restore upgrade, don't forget about:
see KB246133 for more details
to system databases will need to be
re-created or transferred
to be re-created
re-setup & the standby server also
upgraded
有一个 DTS 包的迁移工具，但我不会使用它。 SSIS 比 DTS 好得多，您应该：
如果您不了解 SSIS，这个想法对您来说毫无意义。 例如，我只是在想以前如何在 DTS 中进行循环 - 查找和修改您想要循环回的优先级约束的整个过程。
SSIS 实际上有一个 For 循环容器，它可以循环一组数字、行集中的行、文件夹中的文件等。没有优先级约束和隐藏脚本的黑客。
There is a migration tool for DTS packages, but I wouldn't use it. SSIS is so much better than DTS that you should:
This idea will make no sense to you if you don't know SSIS. For instance, I was just thinking about how I used to have to do loops in DTS - that whole business with finding and modifying the precedence constraint you wanted to loop back to.
SSIS actually has a For Loop container that can loop over a set of numbers, over the rows in a rowset, over files in a folder, etc. No hacks with precedence constraints and little hidden scripts.
只要安装了向后兼容性，DTS 软件包在 2008 年仍然可以照常运行。 以下是使用向导的升级的链接。
DTS packages can still be run as usual in 2008 as long as Backwards Compatibility is installed. Here's the link to upgrading which uses a wizard.
我推荐 Pragmatic Works 的一个名为 DTS xChange 的工具。 它处理大部分迁移并帮助您继续工作。 您将有其他机会学习 SSIS 的新知识，但您可能需要结束您的项目。 可以在 http://www.pragmaticworks.com 下载
I'd recommend a tool from Pragmatic Works called DTS xChange. It handles most of the migration and helps you get on with your job. You'll have other opportunities to learn SSIS on new stuff but you need to probably wrap up your project. It can be downloaded at http://www.pragmaticworks.com