Thank you Maureen, I am looking through that product now. I cant believe that the one job I really need to do, transfer data between my test/staging database and the live production database is nearly impossible to do.
I have a shared host for these sites, and therefore I dont have console access. I cant do things like upload a backup and restore, or detach, ftp and attach it remotely. It requires administrator access to do that. Doesnt anyone else in the world ever transfer data between databases???? Cheers Mike Kear Windsor, NSW, Australia 0414 622 847 Adobe Certified Advanced ColdFusion Developer AFP Webworks Pty Ltd http://afpwebworks.com Full Scale ColdFusion 9 Enterprise hosting from A$15/month -----Original Message----- From: Maureen [mailto:[email protected]] Sent: Wednesday, 3 March 2010 3:32 PM To: sql Subject: Re: Importing into remote SQL2005 using express Have you checked out Toad? I'm fairly sure it will let you copy between schemas on two different servers. I know the Oracle version does. On Tue, Mar 2, 2010 at 3:18 PM, <[email protected]> wrote: > > What should I use to move tables and data from my dev machine to my (remote) > live database? Will the express version of Visual Studio handle that? > Im hoping to find a free (or nearly free) tool to handle movement of data > between my dev machines and my remote databa ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3286 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
