| 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 | OS | debian | OS 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 |
|
Relationships 
Relationships 