I use http://www.red-gate.com/products/SQL_Data_Compare/ Cannot live without it. While you're at it, be sure to pick up a copy of http://www.red-gate.com/products/SQL_Compare/ or just buy http://www.red-gate.com/products/sql_bundles/SQL_Comparison_Bundle.htm which includes both.
On Wed, Mar 3, 2010 at 12:23 AM, Mike Kear <[email protected]> wrote: > > Now that my dev machine is being rebuilt, one of the things i have to > do is work out if the way I've been doing things is still the best way > of doing them. > > The subject that's exercising my mind right now is how to transfer > data between my staging MS SqlServer2005 database and the production > database. This has to happen a lot - several times a week. Up to > now I've been using a beta version of Visual studio that takes about > an hour to transfer a 750MB database and has to be done manually > because despite asking on many forums many times, i have never been > able to find out how to automate it . > > I'm using the free SQLServer Express and would you believe it - import > and export is one of the disabled features. A kind person suggested > Toad SQLServer edition - but i cant see how to transfer data between > databases there either. There's an export feature, but unless i'm > missing something, i cant export to another database - only to an XML > or delimited file. > > I cant ftp and import on the remote database, because i don't have > server administrator access. Only dbo access. you cant restore a > backup, attach an FTP'd database, import from a file if you only have > dbo access on SQLServer you have to have server console access. And > no shared host is going to give that access to anyone. > > So how does everyone upload data to their shared hosting remote databases?? > > Cheers > Mike Kear > Windsor, NSW, Australia > Adobe Certified Advanced ColdFusion Developer > AFP Webworks > http://afpwebworks.com > ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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/cf-talk/message.cfm/messageid:331297 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
