Hi all,
Just throwing our hat into the ring to say we are having exactly the same problems that Mike is describing. What used to be a very straightforward task of copying objects between databases using DTS, simply doesn't work using the supplied SQL Server 2005 tools. Sometimes it starts the copy and just hangs there for hours without completing. Other times, even worse, it says it is complete but has failed to copy large chunks of data. There are a bunch of commercial tools out there that we've started looking at, e.g. http://www.red-gate.com/ , but its hard to justify the cost of these when the tools to do this are actually supplied with the software you've just spent a lot of money on. Management (quite understandably) reads the side of the box and says "It says you can do this already...why are we spending more money?" Most instructions and tutorials on how to do this assume you have full administrative and file access to the database you are working with. But as web developers we are often working with remotely hosted and managed databases. Any help you can find within Microsoft would be much appreciated Scott! Thanks. -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Kear Sent: Monday, 1 October 2007 10:54 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: MSSQL 2005 Developer Edition Sorry Steve, but to use replication you have to have DB Administrator rights on th systems that i host sites on, including Hostmysite. And using the Import/Export tool you describe works, but you can't save the specifics even though it pretends you can. What it saves is an empty spec that does nothing next time you call it up. On one of my sites, it takes an hour to specify each of the 83 tables, and each one has to be specified because the default is not to replace all records but append the incoming records, giving them all new keys. Then I save that spec before running it, so i can use it again, the download works. Next time i call up that same job to run it a second time, nothing happens. It appears to open, validates, etc but doesnt actually download anything. So it all has to be specced out again. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
