MantisBT - opensim
View Issue Details
0008312opensim[GRID] Other Servicepublic2018-04-10 23:042018-04-14 12:09
master (dev code) 
Standalone (1 Region) , Standalone (Multiple Regions) , Grid (1 Region per Sim) , Grid (Multiple Regions per Sim)
BasicPhysics, ODE, BulletSim, ubODE, Other
Unknown, Mono / Linux32, Mono / Linux64, Mono / Windows, Mono / OSX, .NET / Windows32, .NET / Windows64
0008312: differences between sqlite and mysql tables
there are fields in tables, which exists in sqlite but not in mysql and vice versa. the order of fields and the naming might also mismatch. i attached a spreadsheet with some of the differences. i reordered some table fields to get a better overview of mismatches. i also attach a little perl script, which helped me to migrate from sqlite to mysql.
dump the database schemata and have a look on the differences.
migrate from sqlite to mysql might disorder scripts in linked objects, because sqlite didn't keep the link number.
No tags attached.
? opensim sqlite vs mysql.ods (26,541) 2018-04-10 23:04
? (3,414) 2018-04-10 23:09
Issue History
2018-04-10 23:04thomaxNew Issue
2018-04-10 23:04thomaxFile Added: opensim sqlite vs mysql.ods
2018-04-10 23:09thomaxFile Added:
2018-04-13 12:12aiaustinNote Added: 0032639

2018-04-13 12:12   
If this can get checked... it would be worth making this consistent also to PostgresSQL and MSSQL to.