check out sql litespeed for very quick and powerful backup and restore. Can be a handy way to move them about - although I must admit I'm out of date now as I tend to stick to postgresql and mysql which have very simple porting methods.
Toby On 05/01/2009, at 11:30 AM, Mike Kear wrote: > I'm heartily sick of the tedious way I have to spend half a day or > more EACH WEEK uploading and downloading databases from my > SQLServer2005 web sites. > I'm going to have another go at learning the best way to do this . . > > Can someone please give me some help... IN the old days I used to > have a > DTS task running overnight automatically, copying databases to and > from my dev environment to the production web sites. > > Since SQLServer2005 there has been no way that I can find, to create > a DTS task and reuse it EACH TIME I have to create it, and regardless > of whether I save the DTS task or not, it's not available next time > for me to reuse. > I have ot create it all over again. Needless to say it's really > PISSING > ME OFF! > > Can someone please tell me how I can create a method of copying entire > databases which might have 40tables or more with the indexes, and key > relationships etc from remote servers to my local database server, or > conversely from my dev environment to my production server. > > And also how I can do this in a way that the task is repeatable > without having to be created every time. > > I've tried using Visual Studio 2005 but that has finally defeated me. > I can never find what I want to use, and the MS Help files are total > gobbldegook > to me. I cant make head nor tail of it. After 3 years of > wrestling with > Visual Studio I have had to give up. There's no way to save any > file from > that and reuse it. Not that I've found anyway. The best I've ever > managed to do is create a solution, and run debug every time. And > that > takes 30 minutes to an hour to run a simple job of copying 3 tables, > and ties up my machine completely for the duration. > > I'm sure my problem is that I'm trying to use the wrong tools, or > that I just don't know how to use the tools correctly, but I'm > despairing of ever getting back to the neat and tidy way I had to do > this in the old SQLServer2000 days. > > 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> > > So what do the rest of you people on shared hosts do?? > -- > Cheers > Mike Kear > Windsor, NSW, Australia > Adobe Certified Advanced ColdFusion Developer > AFP Webworks > http://afpwebworks.com > ColdFusion, PHP, ASP, ASP.NET hosting from AUD$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/cf-talk/message.cfm/messageid:317364 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
