Move datafile.db between v11 <-> v16 ??

[Former Member]

Can I take a v11.x .db file and open it with v16 on OS X, mass update some data (edit content of fields in existing records and add new records), then return the edited copy of the .db to the v11 server?  

Thanks,

[jeff_albion · Accepted solution]

Hi Dan,

Yes, this workflow is both possible and allowed. SQL Anywhere 16 can open SQL Anywhere 11 databases directly, without upgrading the format of the database file.

However, if you upgrade or rebuild the version 11 database file on version 16, then the database can then only be ever opened by the version 16 server afterwards.

Note that if you do use the version 11 database on a version 16 database server without upgrading or rebuilding, some version 12 and 16 new features may not be available.

Cheers,

Jeff Albion

SAP Active Global Support

[Former Member · Accepted solution]

Hi Jeff,

That's the answer I was hoping for! Thanks for the help.

Dan Ivy

4D Database Developer

www.4D.com