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:317362 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
