Hi friends..

Sorry my English...because i'm from brazil..

I need have a script of all the tables from my database...how can i extract it ?

I need have a Script to create my database in other computers..and i need to, a script of insert ..

because my tables have data and when i go create my database in other computer i need insert this data.

I use the Pervasive Control Center..

Is possible it  ?

Please..friends..i need yor help's..

If possible, please, don't use a vocabulary difficult...

Thank you very much..

Carlos

From Brazil. 

Carlos,

   Have you tried simply copying the data files and the dictionaries to the other machine?  Then you can create a dsn pointing the the data and dictionaries.  

You did not mention what version you are on.  On 9 and 10, you can right click on the tablename and select edit.  Go to the tab, sql view, and you will get the script.  On 10.10 you can get the scripts of all the tables at once, by right clicking on the database name and selecting 'export table schema.'

Jose 

Thank you Jose ..

I use the version 9, about copy of my data files to other computer i can, but it's not

interesting for me, i'm happy with the version 10, but now i use 9, and if i have 200 tables i go

copy script in the sql view table by table ?

And script for insert's ? ....don't we have this tools in pcc ?

because i have about 15 tables and about 2000 lines in my table's.

Do you know other's tools for working to pervasive, i need this script's of insert's.

Here in brazil, not have information about pervasive...we aren't very much users   

Thank you jose.

Carlos

Carlos,

   In the 9x environment, yes, you will have to copy table by table.

    You can use the table export wizard from PCC tools and bdu utility to load the table or you can do it on the btrieve level using file maintenance.  

Have you tried the ddfbuilder 4.5 at http://ww1.pervasive.com/developerzone/sdk/ddfbuilder.asp?  DDFBuilder has an import and export that uses a sql script when you right click on the table.  In 10 this functionality has moved to PCC.

Jose 

Our tool, DDF2XML, can create scripts for an entire dictionary at one time using the /C option.  There is a limited trial available from our web site at www.goldstarsoftware.com/tools.asp.  Some dictionaries don't export properly, such as those that use the older NOTE, LSTRING fields and such, but this is a limitation of the database that can be manually worked around if needed.

As for moving the data, I would strongly recommend that you use a batch file calling BUTIL -LOAD to load the data.  This is ideal for performance and simplicity reasons, but may require that you do some batch file programming.  If you really want it in SQL, then we have other tools which can help, too.  Our SQLExec tool, available from the same site, provides the ability to export data from a SQL database and then run SQL INSERT statements to import it back in.  If you HAD to have a SQL script (which will run much more slowly), then we could easily modify the SQLExec code to built it for you, complete with the INSERT statements based on the existing data.

Ok, tank you very much friends

With your help i have good ideas for my project,

This is not more problem for me, Tanks your helps.

by 

Carlos.

Brazil