Expect to see a videocast on this soon via askasqlguru.com.
On 10/2/07, Andrew Scott <[EMAIL PROTECTED]> wrote: > > > Mike that is exactly why we purchased Red-Gate SQL bundle. > > > > Andrew Scott > Senior Coldfusion Developer > Aegeon Pty. Ltd. > www.aegeon.com.au > Phone: +613 8676 4223 > Mobile: 0404 998 273 > > > > -----Original Message----- > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On > Behalf > Of Mike Kear > Sent: Monday, 1 October 2007 10:27 PM > To: cfaussie@googlegroups.com > Subject: [cfaussie] Re: MSSQL 2005 Developer Edition > > > For my case (and i might add for most of my hosting clients too) that > pretty well sums is up. > > If we have a site on a shared hosting box, we have two basic needs - > we need to copy the data from the remote site to our local machines, > both for backup of the backup and also so when we're doing development > work so that we're working on realistic data. > > Also there are other sites where the opposite is required. - databases > are changed locally, or CMS work is done locally, then the database is > copied up to the live site to 'publish' the new version of the site. > > I've been transferring whole databases up till now - changed or not, > but to just be abel to transfer the things that have changed would be > far better if that can be done. I know the replication does that, > but you can only get access to replication if you have DB Server Admin > rights. > > once I could do all that automatically using scheduled jobs in > SQLServer2000, now thanks to the 'improved' SSIS, it doesnt work and > it all has to be done manually. > > If you could get someone to help sort out what i'm doing wrong, or > help me find a way to do it automatically again, I'll love ya!! > And there will be lots of people with shared hosting who'll love ya > too, since we can never get DB Server Administrator access to the > boxes. The highest privileges we can get is DB Owner. This is not > just me on my system, but most shared hosting environments, that I've > had experience with. > > Thanks for your interest Scott. > > > 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 > > > > > -- Regards, Scott Barnes http://www.mossyblog.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
