May 25, 2009 at 1:59 pm
I need to find specific details on the migration of database 2000 to 2005, and if there is through a. Mpp would be ideal. Where can the documnetacion?
Thank you
May 26, 2009 at 12:35 am
at MS
- the general page: http://www.microsoft.com/sqlserver/2008/en/us/default.aspx
- "Upgrading to SQL Server 2008" msdn.microsoft.com/en-us/library/bb677622.aspx
Helps you with preparing and planning your migration
- "Microsoft SQL Server 2008 Upgrade Advisor" www.microsoft.com/downloads/details.aspx?FamilyId=F5A6C5E9-4CD9-4E42-A21C-7291E7F0F852
Helps you with preparing and planning your migration of a DB
The upgrade advisor is a MUST DO ! It will point you to issues at db or instance level !!
- "SQL Server 2008 Upgrade Technical Reference Guide" http://www.microsoft.com/downloads/details.aspx?FamilyID=66d3e6f5-6902-4fdd-af75-9975aea5bea7&displaylang=en
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 27, 2009 at 4:21 am
If you are just upgrading database objects (tables, views, usp's, udf's, etc) then you will just need to follow the updade advice from those sources.
If you are upgrading to IA64 (rather than x64) on the hardware side then there are restrictions on what SSIS tasks can do in relation to accessing Office compoents (it can't - that means no Excel import for example, although you can import pure CSV). Also note that DTS is really out of the window so it's a re-write of DTS code into SSIS. (Although you can embed DTS packages into SSIS - probably not the best solution).
Whilst x64 implementations still have challenges IA64 brings a host of other issues that must be addressed before going ahead. Think of having a full test server to try out how things will work in practice.
June 9, 2009 at 8:44 am
the hardest part for us was migrating all the dts packages to ssis. We eventually figured out how to do it and got all 400 of our packages done in just a couple months. PM me if you have this issue too
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply