y********o
发帖数: 2565 | 1 到底有什么典型的问题要注意？
我们公司要从SS2000升级到SS2005，想让我来试一下。但是我又没有做过DBA, 只是做
web development的时候才跟数据库打交道而已。
难道将SS2000的数据库back up然后restore到SS2005不行吗？会有什么大问题吗? 别笑
。 |
B*****g
发帖数: 34098 | 2 http://www.microsoft.com/sql/solutions/upgrade/default.mspx
【在 y********o 的大作中提到】
: 到底有什么典型的问题要注意？
: 我们公司要从SS2000升级到SS2005，想让我来试一下。但是我又没有做过DBA, 只是做
: web development的时候才跟数据库打交道而已。
: 难道将SS2000的数据库back up然后restore到SS2005不行吗？会有什么大问题吗? 别笑
: 。
|
a*******t
发帖数: 891 | 3 the link from Beijing has a lot of info
but in summary, yes, backup restore is ok. Few things thought
1. run upgrade advisor; take action as needed.
2. set compebility level to 90 (2005) unless you need to keep it at 80 |
j*****n
发帖数: 1781 | 4 get upgrade advisor as the start point.
http://www.microsoft.com/downloads/details.aspx?familyid=1470e86b-7e05-4322-a677-95ab44f12d75&displaylang=en
generally DB and SPs are ok, if you have DTS, that's another issue. |
y********o
发帖数: 2565 | 5
Thank you very much. Very helpful, esp., got to know the Upgrade Advisor,
which really helped.
【在 B*****g 的大作中提到】
: http://www.microsoft.com/sql/solutions/upgrade/default.mspx
|
y********o
发帖数: 2565 | 6
If we set the compatibility level to 80, then we don't really need to make
any change to the original database, right? I understand that then we won't
be able to use the SS2005 features. But that's fine.
The documentation at MSDN says that compatibility level 80 will be removed
in future releases of SQL Server.
【在 a*******t 的大作中提到】
: the link from Beijing has a lot of info
: but in summary, yes, backup restore is ok. Few things thought
: 1. run upgrade advisor; take action as needed.
: 2. set compebility level to 90 (2005) unless you need to keep it at 80
|
y********o
发帖数: 2565 | 7
I carefully read the documentation. It seems it has a lot of changes in
system stored procedures. User stored procedures are mostly fine. The outer
join operators *= and =* are deprecated, a slight concern.
I don't know nothing about DTS yet.
【在 j*****n 的大作中提到】
: get upgrade advisor as the start point.
: http://www.microsoft.com/downloads/details.aspx?familyid=1470e86b-7e05-4322-a677-95ab44f12d75&displaylang=en
: generally DB and SPs are ok, if you have DTS, that's another issue.
|
j*****n
发帖数: 1781 | 8 *= and =* are just outer joins, so easy to fix, not a big deal.
quick check: how do I find all SPs contain particular strings?
USE DB_you_want_search
go |
y********o
发帖数: 2565 | 9
Thanks. I think the upgrade advisor can find them out, too.
For practice purpose, I have been trying to iterate through all databases
and all tables of each through sp_msForEachDb and sp_msForEachTable. But it
hasn't been successful.
【在 j*****n 的大作中提到】
: *= and =* are just outer joins, so easy to fix, not a big deal.
: quick check: how do I find all SPs contain particular strings?
: USE DB_you_want_search
: go
|
b********a
发帖数: 213 | 10 Backup everything before you do the migration.
Some DTS packages need to be rewritten. |
n********6
发帖数: 1511 | 11 The system accounts and user accounts, priviledge, and security might also
be an issue and increase the complexity. SS2005 has new system objects.
Complex DTS packages cannot be directly upgrade to SSIS.
It's just my knowledge. I never upgraded from SS2000 to 2005.
【在 y********o 的大作中提到】
: 到底有什么典型的问题要注意？
: 我们公司要从SS2000升级到SS2005，想让我来试一下。但是我又没有做过DBA, 只是做
: web development的时候才跟数据库打交道而已。
: 难道将SS2000的数据库back up然后restore到SS2005不行吗？会有什么大问题吗? 别笑
: 。
|
j*****n
发帖数: 1781 | 12 in addition, there is NO WAY to run DTS under 2k5 64bit, no run-time env
support for it.
【在 n********6 的大作中提到】
: The system accounts and user accounts, priviledge, and security might also
: be an issue and increase the complexity. SS2005 has new system objects.
: Complex DTS packages cannot be directly upgrade to SSIS.
: It's just my knowledge. I never upgraded from SS2000 to 2005.
|
