NUGROHO NOTO wrote: > Thanks. > I will try to contact cfdynamic.com > regarding moving database etc... which I feel a bit scary how to do this.
if you have books-on-line installed, have a look at the "Copying Databases to Other Servers" section. as you can see there are a bunch of ways to handle this, but mainly: - "live" server-to-server (bcp, DTS, replication, etc.) - "dead" backup-restore i'd recommend the "dead" method which you can easily test with your current remote production sql server & your local dev one. do a full backup of your production db, copy it local, then try restoring it on your dev box. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291694 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

