Also have a look at tools such as ApexSQL Studio - this is a one stop shop.
Very nice. -----Original Message----- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: 01 March 2005 14:33 To: CF-Talk Subject: RE: transferring databases ( ms-sql ) Isaac, When transfering a complicated DB I always generate the script with all the dependencies then run the "creates" (not the constraints and indexes). Then I run the DTS to transfer. Doing it that way preserves my identy fields. Then I run the part of the script that handles constraints, indexes, stored procedures and views. If you do it all in the right order its pretty painless. The script generator does a pretty good job. If I have one I need to run repeatedly for some reason I use the drops as well - and I divide the scripts up into tasks that are added to my DTS package before and after - only using the wizard to generate the actual part of the package. -Mark -----Original Message----- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 01, 2005 7:58 AM To: CF-Talk Subject: RE: transferring databases ( ms-sql ) >> From: Protoculture [mailto:[EMAIL PROTECTED] >> I would like to transfer our database from our testing >> server >> to a live server. What is the easiest way to do this? > I always have good luck using DTS. If you know how, or you don't use certain features DTS can be great. It has a tendancy to drop identities and defaults -- oddly enough by design, because the engineers at MS assumed that any transfering of a database would be for the purpose of "replication" to an essentially read-only state for load-balancing purposes (I can only assume). It actually says in the documentation that it drops defaults intentionally. IIRC the only way it retains defaults on a column is if you create default entities in the database and attach them to the columns in your tables -- but then you have the issue of it possibly (likely) attempting to transfer the table before the default is transferred. Then there's the issue of DTS always transfering views in semi-random order so there's no guarantee it won't bomb while it's transferring views, even though it should know better because the database knows what dependencies a view has. People have different results with DTS, so YMMV obviously... I was once able to create a DTS package that would transfer a reasonably large database with many views and defaults with consistent success -- it wasn't an easy task by any stretch of the imagination however, requiring several hand-crafted steps including several steps for views to ensure the views would transfer in the right order. Given the choice between DTS and detach-reattach or backup-restore, I'd probably not choose DTS. s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196935 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
