This is all very frustrating. All I want to do is upload my databases from my dev machine to the host machine, and I cant find anywhere that tells me simply how to do it.
I can buy books. I can buy software, I can download Toad, but have to install it in order to find out if it can upload or download my databases. I've tried wading through some SSIS tutorials, but after spending 5 hours now and getting to part 8, I still can't see how I can use it to upload and download databases Surely this is a common task for web developers isn't it? Don't people do this all the time? I can't believe I'm the only one that wants to copy a database from one SQLServer to another. It there ANYONE who has succeeded in copying an entire database - tables, stored procs, views, triggers, indexes, keys, foreign keys, relationships etc the lot from one SQLServer to another? Can ANYONE point me to a way to do it? Thank you Maureen for your suggestion about Toad, but I have no idea whether it can move data between one database and another, because the site doesn't say so. I have to download the app, install it, do the tutorials and learn the wretched thing before I get to answer that simple question. In the site the "feature list" doesn't give any features at all, just a list of system requirements in order to install it. Can Anyone help me? Cheers Mike Kear Windsor, NSW, Australia Macromedia Certified Advanced ColdFusion Developer AFP Webworks Pty Ltd http://afpwebworks.com Full Scale ColdFusion hosting from A$15/month -----Original Message----- From: Maureen [mailto:[EMAIL PROTECTED] Sent: Thursday, 9 March 2006 8:42 PM To: SQL Subject: Re: SQL2005 how to upload databases? I've dumped all my database tools except Toad. http://www.toadsoft.com/ On 3/6/06, Mike Kear <[EMAIL PROTECTED]> wrote: > I am in a hosted environment. I have 42 more sites to move in, and 35 more > databases. It's proving to be a laborious process. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2453 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
