Here's some even better information on RedGate automation: http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Data%20Compare&c= knowledgebase\SQL_Data_Compare\KB200711000189.htm
Looks like the package you'd want is $695, well worth it if it can be automated and save a bunch of work for you. -- Josh -----Original Message----- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Wednesday, March 03, 2010 9:10 AM To: cf-talk Subject: Re: How do people transfer data between databases nowdays? I say again: http://www.red-gate.com/products/SQL_Data_Compare/ On Wed, Mar 3, 2010 at 11:05 AM, Mike Kear <afpwebwo...@gmail.com> wrote: > > Thanks Will, but the problem at issue is how do people move data from > the staging/dev MSSQL machines to the production MSSQL machines, if > the following limitations apply: > > [A] No console access because it's a shared host so therefore can't > take a backup, FTP It to the remote machine and restore it there. > [B] Replication features of MSSQL wont work either for the same reason. > [C] Can't detach the database on the staging machine, FTP it to the > remote server, then attach it there . no console access. > [D] it must respect the data integrity features of both databases - > default values, auto numbering indexes, foreign keys, non-null fields > etc. > [E] preferably it should be able to be automated, so that on a > schedule, databases can be published to the production site (or the > converse - copied to the local staging server) without operator > intervention. > > I should say that Microsoft dont have such a product - their solutions > can't be automated, or if they can, there's no one at Microsoft in > the last 3 years of asking that can tell me how. > > So can i really be the only person who's using SQLServer in a shared > hosting environment and therefore has to do this on a regular basis? > > I can do as Maureen suggested and write a ColdFusion solution, and > that would work, but its a lot of work for the case where there's a > one-off - an upload of a single table or an initial upload of a > database when deploying the site. > > How do the rest of you do this?? > > A couple of years ago, Microsoft GAVE us for FREE copies of MSSQL2000 > - the full-blown version, which was great, but since then everyone's > moved on to MSSQL2005, which is not compatible. The free express > version has 50 million features that no one would ever use, a > bazillion features that most people would use, EXCEPT unless I'm not > seeing what's staring me in the face, you can't import/export from > one MSSQL database to another. AARRRGGHH!!!!!!! > > 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 > > > > On Thu, Mar 4, 2010 at 12:46 AM, Will Tomlinson <w...@wtomlinson.com> > 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. > >> > >> > > > > +1 dbconvert.com. They have an amazing slick application there. I happen > to use it to convert MSSQL > MySQL. Works like a charm. > > > > > -- > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:331318 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm