On Wed, 15 Mar 2006, ryan bel brillo wrote: > Im using a software ipswitch WS_FTP to transfer the file from linux to >windows. Im not sure before if I configured it to binary transfer but I >tried it again and make sure to configure it and set it to binary >transfer, still im getting the same result. > > Currently, Im trying to create the database in windows then use the >created database as my base db in linux. Then I'll just have to update >the base db in linux using the different sql statement in postgresql and >transfer it back to windows if the base db can still be read with the >updates. > > On trying to read the file on sqlite3 command line program in windows; >I'll try it later.
What version of SQLite are you using on Windows? 3.x where x<3 has problems reading databases created with 3.3 and above due to a small change in file format. Make sure you have 3.3.x on Windows as well. The database itself should otherwise be compatible. Christian -- /"\ \ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL X - AGAINST MS ATTACHMENTS / \