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 <li...@pgrworld.com> 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