> I would like to transfer our database from our testing > server to a live server. What is the easiest way to do > this?
As someone else pointed out, detaching the entire database from the dev server and hooking it back up with the live server is your best bet. If you don't have access to do that on one server or the other, this is the process I've found to work best for me and my databases: 1. Create a blank database on the live server. 2. Generate an SQL Script to include all objects, and under Options, all indexes, triggers, keys, etc. Do not include security options. 3. Execute the script against the new blank database to generate the database schema which should now included everything needed to hold your data. 4. Use a DTS transfer to transfer data only. 5. Serve, and enjoy. Note that if you have constraints on the data you may have more issues than this can address. ----------------------------------- Justin D. Scott Vice President Sceiron Interactive, Inc. www.sceiron.com [EMAIL PROTECTED] 941.378.5341 - office 941.320.2402 - mobile 877.678.6011 - facsimile ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:196936 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
