January 13, 2011 at 11:28 am
Hi,
Our DBA setup 2008 server and now we are moving all our databases on 2000 to 2008 one by one. We are not upgrading all our databases at a time but testing and implementing one by one. Should I just create new database on 2008 and import data from 2000? or create backup files on 2000 and restore it to 2008? We have few DTS packages on 2K, should I convert it to SSIS and how? Please advise.
Thanks.
January 13, 2011 at 3:22 pm
bump!
January 13, 2011 at 4:21 pm
backup and restore is the normal way.
plus after the restore:
set compatibility level to sql 2008 (level 10)
change database owner to match what it was before
run dbcc updateusage
run sp_updatestats (at least, rebuild indexes if you have time)
new schemas will be built for each SQL user, doubt you will want these so drop them
set default schema to dbo for all users (unless objects were not owned by dbo in 2000)
run dbcc checkdb with data purity
set page_verify database option to checksum
backup the database as a new base point.
for DTS if you have time your best bet is to rewrite them from scratch in SSIS. You can set up backward compatibility for DTS and install run time support from the SQL2008 feature pack ( see here) and then rewrite them at your leisure, but this feature will be deprecated so don't use it as an excuse not to bother with SSIS rewrite
---------------------------------------------------------------------
January 18, 2011 at 2:11 pm
Thanks for the detailed answer.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply