Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 5 of 5 total |
Export data to SQL "Insert into..." |
Thu, Aug 7 2014 5:09 PM | Permanent Link |
Michael | In DBISAM you could export tables and data into a "DBISAM compatible" script with insert statements. Can you do this with ElevateDB? I am most interested in getting the "Insert into" commands into a script.
Thanks, Michael |
Thu, Aug 7 2014 5:17 PM | Permanent Link |
Michael | Just to clarify, I want the script to be a ElevateDB compatible script.
Michael wrote: Can you do this with ElevateDB? |
Thu, Aug 7 2014 10:58 PM | Permanent Link |
Raul Team Elevate | On 8/7/2014 5:09 PM, Michael wrote:
> In DBISAM you could export tables and data into a "DBISAM compatible" script with insert statements. Can you do this with ElevateDB? I am most interested in getting the "Insert into" commands into a script. > Check out the reverse Engineer function (right click on database). Make sure you select include rows option on output page to get the data as well. Raul |
Fri, Aug 8 2014 3:57 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Michael
If you only want one or two tables then in EDBManager: 1. open session 2. open database 3. create new sql 4. back on the left hand side select tables 5. drag'n'drop a table onto the blank sql window EDBManager will then insert the code for creating the table and optionally the data (rows) What it will not do is insert any code for creating indices. Can't remember if it does constraints other than the primary key. Roy Lambert |
Mon, Aug 11 2014 6:19 AM | Permanent Link |
Adam Brett Orixa Systems | Micheal,
You should also review EDB's EXPORT TABLE / IMPORT TABLE SQL statements. These offer a different route for data transfer in / out of tables which is very useful and goes far beyond the capabilities in DBISAM. |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |