View Single Post
  #5 (permalink)  
Old 11-22-09, 23:01
AnanthaP AnanthaP is offline
Registered User
 
Join Date: May 2009
Location: India
Posts: 62
What happens to a new file (created on the new server)? What for instance is the machine ID?
Is it possible to export all the old data, purge the data base and import the data back?

"T1" ."Data_Machine_Id" , ----- 3597084467
"T1" ."Sequence_Number" , ----- 5
"T1" ."Owner_Id" , ----- Public
"T1" ."Client_Id" , ----- 090818000033597084467C
"T1" ."Contact_Number" , ----- 0
"T1" ."Private" , ----- 0
"T1" ."Table_Id" , ----- 8
"T1" ."Type_Id" , ----- 3724050020
"T1" ."Doc_Size" , ----- 30
"CONVERT" (IF ("T1" ."DateCol_Date" < '1900-01-01' ,'1900-01-01' ,
"CONVERT" ("T1" ."DateCol_Date" ,"SQL_CHAR" ))+' ' +"CONVERT" ("T1" ."DateCol_Time" ,"SQL_CHAR" ),
"SQL_TIMESTAMP" ), ----- 30 11/18/2009 11:03:02 AM
"T1" ."Ole_Doc_Type" , ----- .txt
"T1" ."DType" , ----- 0
"T1" ."Creator_Id" , ----- MASTER
"T1" ."Entity_Type" , ----- 1
"T1" ."Description" ----- problems

Googling just now gave me this intereasting link for the first part of the problem. Files are stored in DATA\MXZL.MAX - which you probably knew. Maximizer Files

So maybe, just overwrite the file and try (after full backup), then apply some sort of FIX within the maximiser tools eg: Answer

Whats the error code you get? If MXZL.MAX is > 2GB, there will be associated files called MXZL.^01 etc.

As a last resort, you must have looked at the pervasive data tools web site
Data Extractor from Pervasive.SQL | PERVASIVE DataTools

I got interested in pervasive because they are now launching operations and support in India - where I come from.

END
Reply With Quote