Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 4 of 4 total |
Copying a table to another session |
Wed, Dec 2 2015 9:00 AM | Permanent Link |
Matthew Jones | How can I get a reverse engineer version of a table to be able to copy
it and create it in another session? EDB Manager has a Copy table option, but no way to tell it which session to copy it to, so I presume it does it in the current session. Okay, found it, but I think it would be nice to improve. Clicking on the table shows the SQL to create it in the SQL tab at the bottom. Copy that to a script in the other session and execute to create. Would be nice to have this as an option somewhere, like "copy table from..." perhaps. Perhaps also with the content to come over as well. But it is possible anyway. Thanks for listening. 8-) -- Matthew Jones |
Wed, Dec 2 2015 9:37 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Matthew
You're going to love this - 1. Open the database you want to copy from 2. Open Tables view 3. New (sql window) 4. Switch to blank sql window 5. Drag'n'drop table desired onto blank sql window. Dialog <<Would you also like to include the SQL for inserting existing rows ?>> - yes if you want to Without closing anything down 6. Open database you want to copy table to (this can be in the same or a different session) 7. Click back to the sql window 8. Click execute or press F9 - your choice If you're copying lots of rows sit back and enjoy the view Roy Lambert |
Wed, Dec 2 2015 9:53 AM | Permanent Link |
Matthew Jones | Roy Lambert wrote:
> Matthew > > > You're going to love this - > [snip] > If you're copying lots of rows sit back and enjoy the view Even more power, and even more hidden! It needs to be more visible somewhere. -- Matthew Jones |
Wed, Dec 2 2015 10:11 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Matthew
>Even more power, and even more hidden! It needs to be more visible >somewhere. To be fair the only hidden bit is the drag'n'drop. The other parts simply require turning your brain on, or do as I did and do it accidentally and realise what you've done <vbg> Roy |
This web page was last updated on Sunday, May 5, 2024 at 07:30 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |