I think it's called SSIS or something, but awfully complicated and I never got it to work....
I copy production to dev by simply restoring a production backup on the dev server. For db alterations I do it all in TSQL scripts tested and known to work on the dev server, and then run on the production one. Richard -----Original Message----- From: Paul Kukiel [mailto:pkuk...@gmail.com] Sent: 05 January 2009 14:52 To: cf-talk Subject: Re: How do you guys deploy databases to shared servers? Yes these are the 2 that I use. I haven't even used the rest of them. Regards, Paul On Mon, Jan 5, 2009 at 12:28 AM, John M Bliss <bliss.j...@gmail.com> wrote: > I can't live without Red-Gate... > > > Which of them do you use to copy/duplicate/synchronise > > http://www.red-gate.com/products/SQL_Compare/ for DB structure. > http://www.red-gate.com/products/SQL_Data_Compare/ for DB contents. > > On Sun, Jan 4, 2009 at 10:55 PM, Mike Kear <afpwebwo...@gmail.com> wrote: > > > Thanks Paul. I see those Red gates packages are a series of $395 > > applications. My tiny company isn't going to afford $5000 worth of > > tools, or even the bundle price around $1000. > > > > Which of them do you use to copy/duplicate/synchronise databases > > between two servers? > > > > 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 > > > > > > > > On Mon, Jan 5, 2009 at 3:38 PM, Paul Kukiel <pkuk...@gmail.com> wrote: > > > We recently got Red gates toolbelt SQL tools. Like you upgrading/ > > > moving databases was time consuming and difficult. Now its just so > > > much easier. http://www.red-gate.com/products/ > > > SQL_Professional_Toolbelt/index.htm > > > > > > Paul Kukiel > > > > > > > > > > > > On 04/01/2009, at 7:30 PM, 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:317405 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4