DBTools Software - Forums

Anonymous

Home » Forums » DBManager General

copy table command copies only table structure (1315 previews)
copy table command copies only table structure	Posted in 02th, 02/2006 10:57 by j_schatz
I have a table with good data in it. I want to copy that table and its data to a new name for testing experimental code that deletes, modifies and inserts records. I want to leave the original table alone since it contains online customer data. The copy table command copies only the table structure. How can I also copy the data? I see there is a text import but no export. I see DAO import and export but I don't want to involve MS Access if possible. I am running MS Xp with SP2. I have DBTools Professional 3.2.1 Enterprise edition. Jim
Re: copy table command copies only table structure	Posted in 03th, 02/2006 09:11 by support
Hi Jim, This can be easily done by running the command INSERT INTO ... SELECT command in query builder. Optionally you may try the Task Builder to move data from one table to another. This one is very complex but much more configurable. Best Regards, Support / DBTools Software
copy table command copies only table structure (1315 previews)

Legends

Topic has Replies

Topic With no Replies

Home » Forums » DBManager General