aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/Migration.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
2019-05-19Various database fixups.onefang1-1/+1
InnoDB -> MyISAM utf8 if not exists white space
2019-05-19Dump OpenSim 0.9.0.1 into it's own branch.onefang1-13/+13
2010-10-04Formatting cleanup.Jeff Ames1-2/+2
2010-09-18Improve the explanative text of migration failuresJustin Clark-Casey (justincc)1-3/+3
When running for the first time, people see migration failures because of sql statements that are trying to move data from old tables (e.g. users). The amended text attempts to calm their nerves.
2010-09-12Formatting cleanup.Jeff Ames1-7/+7
2010-08-09Even if all data migratios are up to date, still print the current revision ↵Justin Clark-Casey (justincc)1-3/+2
to the log
2010-06-25minor: fix spelling mistake interupt -> interrupt in migrationsJustin Clark-Casey (justincc)1-6/+3
This is for mantis 4783
2010-05-19Kind of fixed Melanie's "Exception(sql)" correctionAlexRa1-2/+2
Throwing an Ex. with SQL command in the message looks weird, this is a bit better, but I'm still not sure if that's the proper way to handle. Also, there is a catch one level up, so is this one necessary?
2010-05-19Change appender to deal with line feeds more intelligently.Melanie1-1/+1
Change migration error reporting to not truncate the statement when reporting. It's a bit messier than the old error reporting, but at least one gets an idea of what could be wrong again. And things look a lot neater now.
2010-05-19Clean up output a bitMelanie1-3/+10
2010-05-19Fix the migration message to say "Continuing" again. Remove line feed, whichMelanie1-1/+1
prevented the full message from displaying.
2010-05-19Remove the return that was inserted in the last merge to allowMelanie1-1/+0
migrations to continue in the face of an error
2010-05-18Make m_log in migrations private. Define new m_log in derived classMelanie1-1/+1
2010-05-18Migration.cs supports single-file migration history formatAlexRa1-104/+233
Scans for migration resources in either old-style "scattered" (one file per version) or new-style "integrated" format (single file "Resources/{StoreName}.migrations[.nnn]") with ":VERSION nnn" sections). In the new-style migrations it also recognizes ':GO' separators for parts of the SQL script that must be sent to the server separately. The old-style migrations are loaded each in one piece and don't support the ':GO' feature. Status: TESTED and works fine in all modes!
2010-05-16Migration.cs supports single-file migration history formatAlexRa1-104/+233
Scans for migration resources in either old-style "scattered" (one file per version) or new-style "integrated" format (single file "Resources/{StoreName}.migrations[.nnn]") with ":VERSION nnn" sections). In the new-style migrations it also recognizes ':GO' separators for parts of the SQL script that must be sent to the server separately. The old-style migrations are loaded each in one piece and don't support the ':GO' feature. Status: TESTED and works fine in all modes!
2010-04-28Refactoring in Migration.cs: "using()" instead of explicit Dispose()AlexRa1-52/+56
This ensures that 'cmd' gets disposed on errors
2010-04-28Fixed comments in Migration.cs: wrong argument order (no change to code)AlexRa1-2/+2
2010-04-23dispose of the DbCommand used to execute migrations after we've finished ↵Justin Clark-Casey (justincc)1-1/+2
with it rather than within the loop disposing of it within the loop causes Mono.Data.Sqlite.dll to get upset, and it's the wrong behaviour anyway
2010-04-22Insert a ROLLBACK command on migration step failure. This ensures thatMelanie1-0/+2
updating the Migrations table will not occur in a partial transaction, which would be auto-rolled-back later.
2010-01-01New LL login service is working! -- tested in standalone only. Things still ↵Diva Canto1-3/+5
missing from response, namely Library and Friends. Appearance service is also missing.
2009-12-28Make Migratons continue int he face of an error. This is required for theMelanie1-1/+8
friends migration, which MAY error out if the old friends table is not in the same database as the new one being created. This error is nonfatal, it would only mean that friends will not be migrated automatically. It would bite people with nonstandard configurations.
2009-11-02Reverting the memory leak patch for MySQL. Problems have been reported with ↵John Hurliman1-41/+38
the grid server after running for several hours
2009-10-04* MySQL data tests now pass by fixing a bad fix for a bad cast on the asset ↵John Hurliman1-38/+41
Local member in MySQLAssetData * First pass at applying the using(){} pattern to IDisposable objects. Always use the using pattern on IDisposable objects whenever possible, do not manually call .Close() or .Dispose() unless there is no other way to write the code. This pass mostly covers OpenSim.Data.MySQL, and should have no functional change (tests still pass)
2009-06-01Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames1-1/+1
LICENSE.txt.
2009-02-12* optimized usings.lbsa711-1/+1
2008-12-08Reinstate setting timeout to never, the default 30 second timeout was ↵idb1-1/+1
causing problems with big migrations
2008-12-02* Reapply http://opensimulator.org/mantis/view.php?id=2710Justin Clarke Casey1-2/+8
* This patch gets NHibernate working *** PLEASE NOTE: This patch now requires the libmono-oracle2.0-cil library to be installed on Ubuntu (to stop the System.Data.Oracle missing failure) *** * Not sure what the dependency is on other distros. Adding this info to http://opensimulator.org/wiki/Build_Instructions would be most welcome * Adds Castle.* libraries that were missing last time (note, dlls have been added from http://downloads.sourceforge.net/nhibernate/NHibernate-2.0.1.GA-bin.zip)
2008-12-01* Unforunately it turns out not to be that simple. Revert the rest of r7560 ↵Justin Clarke Casey1-8/+2
for now.
2008-12-01* From Mantis#2701 - Implements NHibernate data adapter, adds support for ↵Adam Frisby1-2/+8
MsSql2005 to NHibernate. * Patch courtesy of Adminotech and realXtend. Thanks!
2008-09-20remove some extraneous debug messages from migrationsSean Dague1-2/+0
2008-09-12* minor: spelling mistake and message tidying on Migration messagesJustin Clarke Casey1-5/+5
2008-09-01Mantis #2095Melanie Thielker1-5/+5
Thank you, RuudL, for a complete adaptation of migration and estate data to MSSQL, and the updating of the RegionData handling in MSSQL.
2008-08-18Formatting cleanup.Jeff Ames1-16/+16
2008-06-27dr scofield's warning safari:Dr Scofield1-23/+23
* commented out [Obsolete(....)] attributes where no replacement feature was available: if we want to attribute code that we think needs to be reworked, we should define a new attribute and use that instead (together with a little tool to retrieve all the attributed code then) * commenting out unused variables
2008-06-16set CommandTimeout = 0 in the migration commands so that longSean Dague1-0/+2
migrations (like converting asset ids) don't run into the normal 30 second kill switch.
2008-06-16be a bit more verbose about what we are doing on the migrationSean Dague1-0/+7
side so that people don't think we're hung.
2008-06-16fix nhibernate driver so that it starts (based on the appearanceSean Dague1-1/+2
changes it wouldn't come up). include embedded dialect specific sql files for nhibernate migrations figure out how to get the raw db connection so that migrations can work with nhibernate. create initial migration for NHibernate + SQLite + Assets.
2008-06-16change some messages on the migrations front to be Sean Dague1-5/+4
more clear
2008-06-16the beginning of the great id format migration. This makesSean Dague1-0/+2
asset uuids no longer binary. I've tested this migration a few times, and it seems working in all the scenarios I've found but it wouldn't hurt to backup your asset db before running this as it does touch a very sensitive part of our content system.
2008-06-13Update svn properties, clean up formatting, refactor out duplicate ↵Jeff Ames1-7/+16
hard-coded port numbers.
2008-06-11check in working migration code fore SQLite. This Sean Dague1-1/+7
is now using migrations instead of the old model to create tables. Tested for existing old tables, and for creating new ones.
2008-06-10I'm going to need the Version property to manage Sean Dague1-0/+6
migrating from the old to the new system. Silly legacy code.
2008-06-10update of migration code to be more sane on versionSean Dague1-40/+37
tracking, and support sub types that we'll need for nhibernate.
2008-06-10Update svn properties. Formatting cleanup.Jeff Ames1-8/+16
2008-06-09actually create and populate the migrations table correctly.Sean Dague1-8/+25
2008-06-09migrations seem to not break anything at this point. Sean Dague1-12/+24
Tomorrow I'll start trying to integrate them into sqlite to see if this works right for table migration.
2008-06-09move Migration support into OpenSim.Data, because itSean Dague1-1/+1
really turned out to be small enough to not need it's own assembly
2008-06-09fill out some more migration facilitiesSean Dague1-19/+50
2008-06-09more work in progress migration code, still a while beforeSean Dague1-4/+94
this becomes useful
2008-06-09start in on the shell for a generic database versioning module. My Sean Dague1-32/+38
intent is to create an easier way to manage database table versions like the model used for ruby on rails migrations.