将 SQL Server 2000 升级到 2005 或 2008 - DTS 到 SSIS [英] Upgrading SQL Server 2000 to 2005 or 2008 - DTS to SSIS
问题描述
我们的办公室使用 SQL Server 2000，总的来说它很好地满足了我们的需求.我正在研究升级到 SQL 2005 或 2008 的可能性，因为 2000 年没有发现新功能(当我看到索引使用统计数据时，它告诉我哪些索引最常用，哪些从未使用，这让我大吃一惊).
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).
我不太关心如何将数据库从 2000 年移动到 2005 年或 2008 年 - 我只需进行完整备份，然后将备份还原到新的 sql 安装.我担心的是现有的 DTS 包.我们每天都依赖其中的几十个.将现有的 DTS 包转换为 SSIS 有多困难/容易?我必须注意哪些陷阱"?
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?
推荐答案
做备份 &进行数据库服务器升级的恢复有很多问题.最好进行就地升级(您可能想先对服务器进行完整备份)&让 MS 安装程序完成这项工作.2005 支持 2000 个 DTS 包作为 Legacy，因此无需学习 SSIS &除非您有时间，否则转换您的所有包裹没有太多.
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:
- 登录，你需要转移这些，有关详细信息，请参阅 KB246133
- 授予的任何用户和角色权限到系统数据库将需要重新创建或转移
- 需要重新设置链接服务器或远程服务器
- SQL Server 代理作业需要导出-导入
- 任何扩展存储过程需要重新创建
- 需要重新设置复制
- 原木运输将需要重新设置 &备用服务器也升级了
这篇关于将 SQL Server 2000 升级到 2005 或 2008 - DTS 到 SSIS的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
