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:3169 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
