Many errors trying to copy a database on another pc

[f4lch3tt0]

Hi all, I'm italian, sorry for my english.
I'm trying to copy a PSQL database from a server to my laptop.
I installed Pervasive.SQL v8.6, then I copied all the .BTR files from the server to a specific directory on my laptop.
But when I tried to load the database, I noticed that I can't see the tables.
So I tried to uninstall the engine and many other issues, but nothing was helpful.
Now:
1) when I try to add the database, the error is "Pervasive engine or client data source with this name already exists". I just deleted the databases in "Mantain named database" and the file DBNAMES.CFG.
2) when I try to open the Tables of my database (with another name due to the problem before) I can see only 3 icons:
X$Field:
Xe$Id Xe$File Xe$Name Xe$DataType Xe$Offset Xe$Size Xe$Dec Xe$Flags
----- ------- -------------------- ----------- --------- ------- ------ --------
1 1 Xf$Id 14 0 2 0 0
2 1 Xf$Name 0 2 20 0 1
3 1 Xf$Loc 0 22 64 0 0
4 1 Xf$Flags 14 86 1 0 0
5 1 Xf$Reserved 0 87 10 0 0
6 2 Xe$Id 14 0 2 0 0
7 2 Xe$File 14 2 2 0 0
8 2 Xe$Name 0 4 20 0 1
9 2 Xe$DataType 14 24 1 0 0
10 2 Xe$Offset 14 25 2 0 0
11 2 Xe$Size 14 27 2 0 0
12 2 Xe$Dec 14 29 1 0 0
13 2 Xe$Flags 14 30 2 0 0
14 3 Xi$File 14 0 2 0 0
15 3 Xi$Field 14 2 2 0 0
16 3 Xi$Number 14 4 2 0 0
17 3 Xi$Part 14 6 2 0 0
18 3 Xi$Flags 14 8 2 0 0

(18 row(s) affected)


X$File:
Xf$Id Xf$Name Xf$Loc Xf$Flags Xf$Reserved
----- -------------------- ---------------------------------------------------------------- -------- -----------
1 X$File file.ddf 16
2 X$Field field.ddf 16
3 X$Index index.ddf 16

(3 row(s) affected)


X$Index:
Xi$File Xi$Field Xi$Number Xi$Part Xi$Flags
------- -------- --------- ------- --------
1 1 0 0 256
1 2 1 0 290
2 6 0 0 256
2 7 1 0 257
2 8 2 0 291
2 7 3 0 274
2 8 3 1 290
2 7 4 0 275
2 10 4 1 275
2 12 4 2 259
3 14 0 0 257
3 15 1 0 257
3 14 2 0 274
3 16 2 1 274
3 17 2 2 258

(15 row(s) affected)


Any suggestion? Thank you in advance.

 

[mirtheil]

If you only copied the BTR files, you are probably missing the DDF files. When a database is created pointing to a directory that does not have DDFs, empty DDFs are created and you don't see any tables defined in the database.
Make sure you copy all of the DDF files from the server.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[f4lch3tt0]

I forgot t change the Dictionary Location! That was the error.
Now, if I want to delete the databases name created in the past, what can I do?
I can see the tables, but I can't use the name I want, due to the error "Pervasive engine or client data source with this name already exists".

 

[mirtheil]

You might be able to delete the database by clicking on the "Maintain Named Databases" option found by right clicking on the engine name in the Pervasive Control Center.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[f4lch3tt0]

It doesn't work! I did it, I also delete the DBNAMES.CFG but probably PSQL saves the name in a strange file that I cant't find.

 

[mirtheil]

You might also check for an ODBC Datasource name through the ODBC Administrator. Pervasive only stores Database Names in DBNAMES.CFG. ODBC DSN information is stored in the ODBC registry entry (HKLM\Software\ODBC).

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[f4lch3tt0]

Perfect, it was there.

Thank you very much!