search

sudr / dbdeploy

Automatically exported from code.google.com/p/dbdeploy
0 stars 0 forks source link

Let a migration insert non-sql reference data #5

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Often a database migration involves adding reference data to the database.
That reference data might not always be stored in SQL.

For example, GIS data can be stored in shapefiles.  Translating shapefiles
into SQL insert statements massively increases the size of the data, also
the shapefiles can be easily edited and viewed as geometry, while the SQL
cannot.  So, I want to store the shapefiles, not the SQL, in version control.

DBDeply should allow update files to be in other formats and translate
those formats to SQL statements during the migration procedure.

That translation process should be extensible, because data formats will be
application specific.

Original issue reported on code.google.com by nat.pr...@gmail.com on 18 Dec 2008 at 10:55

GoogleCodeExporter commented 9 years ago 
Sorry, that should have been entered as an Enhancement, but I can't change it 
now.

Original comment by nat.pr...@gmail.com on 18 Dec 2008 at 10:55

GoogleCodeExporter commented 9 years ago 
Updated to enhancement

Original comment by gtack...@googlemail.com on 18 Dec 2008 at 2:01