huh? the COMPARE product is the one that copies data and structure between two servers??? Really??
Cheers MIke Kear On Mon, Jan 5, 2009 at 4:28 PM, John M Bliss <[email protected]> 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 <[email protected]> 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 <[email protected]> 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:317383 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
