Tasks

  • Manual operations involving the downloaded FracFocus.org SQL Server 2012 backup file.
    • SQL Server
      • Download latest FracFocus.org data SQL Server 2012 backup file(s).
      • Open SQL Server 2012 Management Studio (SSMS)
        • Rename current SQL Server 2012 FracFocusRegistry database to another name (e.g. FracFocusRegistry_yyyy_mm)
        • Restore the latest FracFocus.org data backup file (BAK), which should create a database entitled “FracFocusRegistry”.
        • If desired:
          • create primary keys, indexes, and views, as seems fit.
          • export the tables to tab-delimited CSV files via queries that compensate for “undesirable” characters (e.g. TABs, LINEFEEDs) embedded within any of the data columns.
            • Navigate to the FrackingData_RZ database
              • Export data to CSV files using the following views:
                • dbo.vue_RegistryUpload_Cleanse_Columns_for_Export
                • dbo.vue_RegistryUploadIngredients_Cleanse_Columns_for_Export
                • dbo.vue_RegistryUploadPurpose_Cleanse_Columns_for_Export
    • Microsoft Access
      • Open Microsoft Access 2013
        • Create a new ACCDB database, e.g. FracFocusRegistry_yyyy_mm.accdb
          • Using ODBC, import the FracFocusRegistry SQL Server 2012 database into the new ACCDB database.
          • If desired, create primary keys, indexes, and queries, as seems fit.
          • “Save As…” a new MDB database.
          • Exit the ACCDB database.
        • Zip the resulting ACCDB database with 7-Zip
        • Zip the resulting MDB database with 7-Zip
    • SQLite 3
      • Copy the current FracFocusRegistry.sqlite database to another name (e.g. FracFocusRegistry_yyyy_mm.sqlite)
      • Open SQLiteStudio 3
        • Using the existing FracFocusRegistry.sqlite database
          • Truncate the following tables
            • delete from RegistryUpload
            • delete from RegistryUploadIngredients
            • delete from RegistryUpdatePurpose
          • Right-click on each of the tables, and import into it using its respective CSV file
          • VACUUM the database
      • Zip the resulting database with 7-Zip
    • PostgreSQL
      • Copy the current FracFocusRegistry database to another name (e.g. FracFocusRegistry_yyyy_mm)
      • Open PgAdmin III
        • Using the existing FracFocusRegistry database
        • Truncate the following tables
          • truncate table RegistryUpload
          • truncate table RegistryUploadIngredients
          • truncate table RegistryUpdatePurpose
        • Right-click on each of the tables, and import into it using its respective CSV file.  Be sure to use ‘WIN1252’ encoding.
        • VACUUM the database
        • Backup the database to a .BACKUP file
      • Zip the resulting .BACKUP file using 7-Zip
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: