I had created and filled a database file on Mac OS X 10.6. I then transfered and use that very same file on Windows 2008 Server. It works fine and I can't see any obvious problems. To be a bit more sure I would like to know if this is fully support by Sybase? What are the experiences regarding creating a database file (and log) on one OS and move it to another OS? I am also wondering about the encoding of the file, line breaks etc., which are different for the different platforms. Is this internally handled?
Best regards, Robert
asked 11 Aug '11, 08:50
Yes, moving databases between platforms is fully supported by SQL Anywhere.
All integer data within the file is stored in little endian (but users don't really need to know this).
[n]varchar data is stored in the character set specified when the database was created. Line terminators are up to the application developer to decide - i.e the database just stores the data that is given to it.
answered 11 Aug '11, 08:53