Yes. I manage SQL Server servers professionally as a consultant and have upgraded numerous databases (and SSRS reports and DTS/SSIS packages) over the years. The methods I suggested are correct and recommended ways to upgrade SQL Server databases. Both methods are reliable and testable. I also own commercial products that assist with migrating database users, SQL Agent jobs, and other objects that are not contained in the database data file being upgraded.
Another method, which is even easier, is to do an in-place upgrade where you let the installer handle nearly everything. This method is more risky because it is harder to reverse if something goes wrong and it is harder to test in advance. It is a reasonable upgrade path to take in many cases. -Mike Chabot On Mon, Apr 26, 2010 at 6:53 PM, Paul Ihrig <pih...@gmail.com> wrote: > > yeah. but in the wild is that reliable, testable et... > > On Mon, Apr 26, 2010 at 6:13 PM, Mike Chabot <mcha...@gmail.com> wrote: > >> >> I would advise avoiding the migration wizard in SSIS. In my experience >> it doesn't work very well. It is easier and faster to use the >> backup/restore or detach/attach methods when it comes to upgrading SQL >> Server. >> >> -Mike Chabot >> >> On Mon, Apr 26, 2010 at 6:23 AM, Paul Ihrig <pih...@gmail.com> wrote: >> > >> > hey guys. >> > i am in a pickle. i dont know sql server 2005, and i have to migrate from >> 2k >> > to 2005. >> > the ssis data migration wizard seems fine after i tweak packages. except >> for >> > 1 table that is throwing me. >> > >> > the table has 30000 records or so. one of the columns is of type image. >> > the package just runs for hours at a time. and i kill it because i dont >> see >> > any results at about 15000 records. >> > >> > how can i do this better? >> > is there an example you know of to loop through a migration? like 1000 >> > records at a time. >> > or using multiple threads. again i am newb so 2005 book recomendatiuons >> > would be fantastic. >> > >> > and linked examples that might help me. >> > >> > thanks guys. >> > -paul >> > >> > >> > >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333144 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
