In Toad, you make an ODBC datasource for each database, connect to both from the File, New Connection menu option, right click on the object or objects you want to move, and select either the Create in New Schema for your tables, procs, etc.. or copy data for your data. It's a fairly straight forward process. Sorry I wasn't clearer in my message, but I'm just swamped with work. Email me offlist at [EMAIL PROTECTED] if you need more info. Toad is amazingly easy to use.
On 3/9/06, Mike Kear <[EMAIL PROTECTED]> wrote: > 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:2456 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
