@@Dave: Thanks for your reply Dave. Actually SQLServer USED to have everything I needed right up to SQLServer2000. Then when they made the 2005 version they wrecked everything for shared hosting. I'm not sure how come I'm the only person apparently with this problem, because there must be millions of SQLServer2005 databases in shared hosting environments.
I have made such a fuss at Microsoft over it, I have eventually made contact with one of the developers on that team, and he told me that they had never thought shared hosting might be a factor they should consider. To my astonishment, they thought every web site with MSSQLServer would be on a server owned by the web site owner. Good grief!! To my dismay, this guy also told me that the feature list for SQLServer2008 had already been frozen and shared hosting customers were left out in the cold again. It would be at least 2010 before any features to cater for shared hosting could be incorporated in the product. Anyway.. . by a circuitous route, I found out about the Database Publishing Wizard, and I'm surprised that in all my fussing and yelling at MS about this problem, no one there thought to tell me about it. Anyway I downloaded it, and it gives me a 85MB long SQLstatement (or series of statements) that takes an hour to execute. Means in order ot update the database, I cant upload the changes, I have to upload the whole database, and take the site off line for an hour. I'm pretty grumpy about that but it's a step forward, if only a small one. I guess what I need to do is migrate away from MS SQLServer but that isn't something I'm eager to do in a hurry. There are all kinds of implications to changing databases. Not the least of which is a whole host of tests to ensure the integrity of the data I'm moving and rewriting all my code generators that write my components. GRRRRRRRRRRRRRRRRRRRRRRR!!!!!!!!!!!!!!!!! Thanks for your input Dave. @@Manish: I got into Coldfusion 12 years ago because I was so frustrated with Perl - I appreciate your suggestion, and I'm sure you're right but I will cut off an arm with a rusty piece of tin can before I'll look at Perl again. <g> Cheers Mike Kear Windsor, NSW, Australia 0422 985 585 Adobe Certified Advanced ColdFusion Developer AFP Webworks Pty Ltd http://afpwebworks.com Full Scale ColdFusion hosting from A$15/month -----Original Message----- From: Konopka, Dave [mailto:[email protected]] Sent: Tuesday, 6 January 2009 6:11 AM To: sql Subject: SPAM-MED: RE: How do i . Copy a database to a remote server? Hi Michael, I'm not sure if someone else has already gotten back to you -- Check out the SQL Server Hosting Toolkit. There's two tools, the one you want is the Database Publishing Wizard. It will script out all the objects, permissions, and data from your source database. Then you can take the script and run it against your destination database. This is something that's been built into MySQL clients for quite a while now. It's always annoyed me that SQL Manager tools haven't had anything similar. But the Database Publishing Wizard has served me well for hosted databases. Here's the URL: http://www.codeplex.com/sqlhost Dave Konopka http://imakewebjunk.com -----Original Message----- From: Michael Kear [mailto:[email protected]] Sent: Sunday, January 04, 2009 7:23 PM To: sql Subject: RE: How do i . Copy a database to a remote server? Incidentally, just as an additional comment to my plea ... I cant use the copy database wizard, because it's a shared server and I don't have admin rights. So I cant create a database on the remote server using SQLServer management studio. For the same reason I cant create a backup and then restore it on the other server.. For the same reason I cant use replication in any way. For the same reason, detaching, FTP then attach to the other server is out as well. I think Microsoft forgot entirely about the thousands of people using shared hosting servers when they developed SQLServer2005. And I'm told there's no provision for it in the new 2008 version either. <sigh> Cheers Mike Kear Windsor, NSW, Australia 0422 985 585 Adobe Certified Advanced ColdFusion Developer AFP Webworks Pty Ltd http://afpwebworks.com Full Scale ColdFusion hosting from A$15/month ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3170 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
