Backup your dev database to a file, upload it to live server, and force a restore over the current db, works for me.
-----Original Message----- From: Jamie Jackson [mailto:[EMAIL PROTECTED]] Sent: 28 February 2002 16:37 To: CF-Talk Subject: Moving MSSQL DB from Dev to Prod What's the typical way to copy one's development DB to production (SQL2000)? Changes will commonly be made on Dev, and there will be an existing version on production which will need to be overwritten. I know about the "copy database" wizard, but AFAIK, it doesn't work if the DB already exists on the production server. Finally, is there a resource concerning general CF/MSSQL interaction issues and best practices? Thanks, Jamie ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
