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 <[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. >> >> > > +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:331314 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
