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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
