View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] |
ID | Project | Category | View Status | Date Submitted | Last Update |
0008312 | opensim | [GRID] Other Service | public | 2018-04-10 23:04 | 2018-04-14 12:09 |
|
Reporter | thomax | |
Assigned To | | |
Priority | normal | Severity | minor | Reproducibility | always |
Status | new | Resolution | open | |
Platform | tinkerboard | Operating System | debian | Operating System Version | |
Product Version | master (dev code) | |
Target Version | | Fixed in Version | | |
|
Summary | 0008312: differences between sqlite and mysql tables |
Description | 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.
|
Steps To Reproduce | dump the database schemata and have a look on the differences. |
Additional Information | migrate from sqlite to mysql might disorder scripts in linked objects, because sqlite didn't keep the link number. |
Tags | No tags attached. |
|
Git Revision or version number | 96aecf80ef933273bc75e1d77d9b5137fb05505a |
Run Mode | Standalone (1 Region) , Standalone (Multiple Regions) , Grid (1 Region per Sim) , Grid (Multiple Regions per Sim) |
Physics Engine | BasicPhysics, ODE, BulletSim, ubODE, Other |
Script Engine | |
Environment | Unknown, Mono / Linux32, Mono / Linux64, Mono / Windows, Mono / OSX, .NET / Windows32, .NET / Windows64 |
Mono Version | None |
Viewer | |
|
Attached Files | opensim sqlite vs mysql.ods [^] (26,541 bytes) 2018-04-10 23:04
MIGRATE.pl [^] (3,414 bytes) 2018-04-10 23:09 |
|