Code Monkey home page Code Monkey logo

msaccess-vcs's Introduction

MSAccess-VCS

Export MSAccess object to text files and help to integrate with any version control system

An MS Access solution is compound by any of the following components:

  • VBA code in modules and classes
  • Forms: design and VBA code
  • Reports: design and VBA code
  • Queries: Query definition. Only for mdb files
  • Macros
  • Access Pages
  • Tables: only for mdb file format
  • Database properties
    • Database properties, including startup form options
    • Table relations: only for mdb files
    • References: References to other libraries or MS Access files

Suported file formats

  • mdb: Classic file format (Access 2002-2003 format onwards)
  • adp: Access projects: in this files, queries and tables are stored in a sql server database, which has tools enought to export and create sql scripts.
  • accdb: New file format for Access 2007 and following

Tools

  • GUI application: User friendly usage
  • Command line application: for CI/CD servers and automated taks
  • MS Access Add-on (on a future relase)

msaccess-vcs's People

Contributors

mnieto avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar

msaccess-vcs's Issues

Profile management

Use profiles for each database with the below info:

  • Database file
  • Working copy folder
  • Import/Export options
  • Last export datetime
  • other...

The profile can be saved with .accvcs extension associated to MSAccess-VCS application. Also, usual mdb, accdb... extensions can be associated with MSAccess-VCS to allow the command "Open with..."

Maintain in the application a MRU list of profiles

Gather modified objects from last export

This feature would allow automatic export of all modified objects

  • It could be integrated in an Access Add-in, and export modified objects when exiting from Access
  • This could allow to preset the objects to export in the standalone GUI
  • Add a flag in the command line tool

NOTE: Needed to compare with existing files to detect removed objects

Create ExportOptions object and pass it to ObjectTree.SaveSelectedObjects

This options could include:

ExportOptions:

  • Clear folder structure before export [Default: true] In this way source code management tool will detect removed objects from Access database
  • Export queries as SQL [Default: false] By default queries are exported by Access.Interop. This could be a flag enum to allow to export in default format, sql, or both
  • Export table data
  • Use custom file extensions: By default all generated files have .txt extension. But external editors can take advantage of different file extensions for syntax hightlight
  • LogLevel and LogFile

Add option for import Relations

Default behaviour is replace all relations with new ones.
Add an option to choose between

  • To keep existing relations and add the imported relations
  • To remove existing relations and add the imported relations

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.