>> 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196921 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
