That's not actually true All you need is to have DB Owner permissions. With those permissions you basically can do anything you want on the database. I use the Import/Export function. Using this you can choose what you want to copy, whether it be views or specific tables. You can even specify the data based on a query so if you only want data created between specific time frames, as long as the data has date stamps you can do that as well.
The only thing you cant do is do remote backups but having the ability to transfer data from one SQL server to another is just as good. U can also schedule DTS packages to do the same thing. -----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 On 10/1/07, Scott Barnes <[EMAIL PROTECTED]> wrote: > Ok, > > Tracking down some of the folks within Microsoft to get some sort fo > understanding around this. It's important to me that you guys get a > response from this as it sounds like a legitatmite beef. I'm just > hoping it's a case of "not understading the full features/services of > the said product"... I'm no SQL guy, thus I ring in some of our MVP's > but leave it with me and I'll track some braintrusts down in redmond to give some responses to this. > > As for Andrew & I? *shrug* didn't think it was a cross fire more of > friendly jabs heh :P. > > Essentially the situation is for you guys (to distill this down) is > that you're hosting databases on either dedicated or shared hosting, > you want the ability to suck your own data back to base, in an easy > fashion that can be scheduled. This does not involve an FTP events > calendar approach but a direct packaged approach *much like if you > were to remotely DTS in, get the schema, suck down the schema first > and then suck down the data within the schema - but only the bits that > have changed maybe?* > > > > On 10/1/07, Mike Kear <[EMAIL PROTECTED]> wrote: > > > > > > I dont want to join the acrimonious cross fire between Scott and > > Andrew, > but I will add that since SQLS005, it's been a big problem for me to > backup and publish my databases. > > > > In the previous version, SQL2000, I had my dev server automatically > running DTS jobs every night, to copy some databases to my local dev machine > and so to send live some databases. It was quick and happened > automatically. Correctly, reliably, every time. Unattended. > > > > > > Then they "Improved' the product and SQL2005 dropped the DTS. They > invented the "much better" SSIS instead. (Yes I know you can use existing > DTS packets but you can't make new ones) . Now it takes me about half an > hour to MANUALLY backup or publish every database. I have made > numerous attempts to schedule a task to download a remote database over TCP/IP and it > just doesnt happen. Either nothing happens, or the job starts and then > ends without doing anything. I can't even save a job to re-use it ... I > have to create an mport spec each time. If i save the SSIS spec, it saves > empty. Great for databases with 80 tables! Easy to soak up an hour or > two each time. Needless to say i dont take a daily copy of 40 databases > any more. > > > > You cant use any of the synchronising options either on a shared > > hosting > setup, because you need to be a server administrator and in a shared > environment that would never happen. > > > > > > I am just hoping upon hope that the systems guy is making reliable > > backups > every night as he's supposed to. I just bet that if i ever need to go back > to backup, that'll be the day that Murphy's law will apply and therell > be no backup. > > > > Now I see today that there's another version of SQLServer due out > > soon and > i'll be ready to bet that the new version is even more "Improved" and > even more bloated than SQL2005. > > > > > > Sometimes I just wish they didnt "Improve" products that dont need > improving. I wish the marketing people would pull their heads in and shut > up and leave well enough alone. > > > > > > 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 10/1/07, Andrew Scott < [EMAIL PROTECTED]> wrote: > > > > > > Well how else do you expect to do remote backups, from a server to > > > your > local machine? > > > > > > > > > > > > > > > > > > > > > > -- --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
