Re: ssis 2005 question
yeah we do have them linked. so select into may be better. i cant detach and reattach because we are changing the table names of about 90% of the tables.. or that's what i am telling my self.. i really do appreciate your guys opinions. thanks a bunch -paul On Mon, Apr 26, 2010 at 10:20 PM, rex wrote: > > +1 > > This is indeed the way to go. > > Another option, since you manage both servers: link one server to > another and just do an SELECT INTO: > > SELECT * INTO newtable FROM 2KServer.db_name.dbo.table_name > > - Rex > > Mike Chabot 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 > > > > > > ~| 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:333148 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ssis 2005 question
+1 This is indeed the way to go. Another option, since you manage both servers: link one server to another and just do an SELECT INTO: SELECT * INTO newtable FROM 2KServer.db_name.dbo.table_name - Rex Mike Chabot 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 > > ~| 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:333145 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ssis 2005 question
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 wrote: > > yeah. but in the wild is that reliable, testable et... > > On Mon, Apr 26, 2010 at 6:13 PM, Mike Chabot 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 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 3 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
Re: ssis 2005 question
yeah. but in the wild is that reliable, testable et... On Mon, Apr 26, 2010 at 6:13 PM, Mike Chabot 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 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 3 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:333142 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ssis 2005 question
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 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 3 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:333140 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ssis 2005 question
yeah.. i dont think they will let me do that in qa or prod. seems simple, and makes sense.. On Mon, Apr 26, 2010 at 5:04 PM, J.J. Merrick wrote: > > Last 2k to 2k5 migration I did was basically just detaching the DB and > then moving the MDF files and then attaching it to the 2k5 server... > Seemed to work like a charm. > > On Mon, Apr 26, 2010 at 2:02 PM, Morchella Deliciosa > wrote: > > > > just under a gigabyte. > > > > i need to find an example on getting record count of source table and > looping the inserts say 1000 at a time. > > > > right now its just delete destination grab source and insert into > destination. > > > > but google is failing me.. > > ssis loop recordcount insert > > > > > > > > > > ~| 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:333138 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ssis 2005 question
Morchella, I'm not sure what to tell you... importing explorting image data types means a lot of binary data flowing through the drive and very large prepared statements. -mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Morchella Deliciosa [mailto:pih...@gmail.com] Sent: Monday, April 26, 2010 2:03 PM To: cf-talk Subject: Re: ssis 2005 question just under a gigabyte. i need to find an example on getting record count of source table and looping the inserts say 1000 at a time. right now its just delete destination grab source and insert into destination. but google is failing me.. ssis loop recordcount insert ~| 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:333135 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ssis 2005 question
Last 2k to 2k5 migration I did was basically just detaching the DB and then moving the MDF files and then attaching it to the 2k5 server... Seemed to work like a charm. On Mon, Apr 26, 2010 at 2:02 PM, Morchella Deliciosa wrote: > > just under a gigabyte. > > i need to find an example on getting record count of source table and looping > the inserts say 1000 at a time. > > right now its just delete destination grab source and insert into destination. > > but google is failing me.. > ssis loop recordcount insert > > > > ~| 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:333132 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ssis 2005 question
just under a gigabyte. i need to find an example on getting record count of source table and looping the inserts say 1000 at a time. right now its just delete destination grab source and insert into destination. but google is failing me.. ssis loop recordcount insert ~| 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:333129 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ssis 2005 question
Paul, How big is the DB on the 2000 server (how big is the MDB file). Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Paul Ihrig [mailto:pih...@gmail.com] Sent: Monday, April 26, 2010 5:23 AM To: cf-talk Subject: ssis 2005 question 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 3 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:333121 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm