首页 \ 问答 \ 是否有任何外部工具在php / java中为所有数据库对象生成更改日志文件?(Is there any external tool in php/java to generateChangelog files for all database object?)

是否有任何外部工具在php / java中为所有数据库对象生成更改日志文件?(Is there any external tool in php/java to generateChangelog files for all database object?)

我正在尝试将liquibase工具添加到我的开发环境中以管理数据库迁移。 鉴于功能集,它看起来非常灵活和有前途。 我的第一个显而易见的问题是如何将所有现有模式导出到单个文件(表,触发器,函数和存储过程)中。 ?

liquibase是否有任何工具/扩展来执行此类任务。

我试过命令行选项liquibase generateChangelogs ,但不幸的是它生成了单个changelog文件(没有存储对象-fun / pro / trig)

使用bash / java /任何linux标准xml处理命令行工具的任何东西都是值得注意的

这是我想要做的: -拥有mysql函数/存储过程/触发器/表等的xml模板

  • 查询所有表/函数触发器等的现有数据库。遍历每个并解析相应的模板并为每个对象生成changelog文件

  • - 将每个文件存储在当前位置的相应控制器中,例如

    /数据库

     ---/functions
    
     ---/procedures
    
     ---/triggers
    
     ---/views
    
     ---/tables
    

谢谢


I am trying to add the liquibase tool into my development environment to manage database migrations. Given the feature set it looks very flexible and promising. My first obvious question is how I can export all the existing schema into individual files (tables, triggers, functions and stored procedures ). ?

Is there any tool/extension for liquibase to perform such task.

I have tried command line option liquibase generateChangelogs , but unfortunately it generates single changelog file ( without stored objects -fun/pro/trig)

anything using bash/java/any linux standard xml processing command line tool is appreciable

Here is what I want to do : -Have xml templates for mysql function/stored procedure /trigger/table etc

  • query existing database for all tables/function triggers etc.. go through each and parse respective template and generate changelog file for each object

  • -- store each file in respective director under current location e.g

    /database

     ---/functions
    
     ---/procedures
    
     ---/triggers
    
     ---/views
    
     ---/tables
    

thanks


原文:https://stackoverflow.com/questions/14318346
更新时间:2019-12-03 08:12

最满意答案

这是不可能的,但您可以使用该命令生成初始更改日志,然后编写一个分隔对象的脚本。 然后只需创建一个包含其他更新日志的主更改日志。

查看我在Liquibase上的帖子( http://scalabilitycookbook.com/2012/10/05/control-your-database-schema/ )了解详情。


This is not possible, but you can generate the initial changelog with the command and then write a script that separates the objects. Afterwards just create a master changelog that includes the others.

Check my post on Liquibase ( http://scalabilitycookbook.com/2012/10/05/control-your-database-schema/ ) for details.

2013-01-20

相关文章

更多

最新问答

更多
  • jsPlumb draggable element javascript函数(jsPlumb draggable element javascript function)
  • MVC4:ViewModel(带有radiobuttonlist)在HttpPost之后为空(MVC4: ViewModel (with radiobuttonlist) is empty after HttpPost)
  • 如何在同一帐户上设置“Dev repo”(在prod和团队之间)(How to set up a “Dev repo” (between the prod and the team) on the same account)
  • 如何在tcl中将eth0配置为发送方udp端口(how to configure eth0 as a sender udp port in tcl)
  • 如何在datarow []中的列中找到最大值?(How to find max value in a column in a datarow[] ?)
  • 如何使用预定义文本替换来自数据库的部分结果(How do I replace part of result coming from Database with predefined text)
  • Selenium Java注入了新的Javascript函数(Selenium Java inject new Javascript function)
  • 使用.on的多个下拉菜单选择文本仅适用于第一个下拉列表(Multiple Dropdowns Menu Selection text using .on works only on first dropdown)
  • 快速将黄土曲线添加到大型数据集图中的方法(Quick way to add loess curve to large data set graph)
  • FilteringSelect in mvc(FilteringSelect in mvc)
  • 在Delphi XE2中开发Mac或iOS应用程序需要哪些硬件/软件?(What hardware/software is necessary to develop Mac or iOS apps in Delphi XE2?)
  • 在原型的构造函数中初始化属性时获取“未定义”(Getting 'undefined' when a property is initialized in the constructor of a prototype)
  • 通过越狱加载的应用程序的Documents文件夹位置(Location of Documents folder for an app loaded via jailbreak)
  • 在OpenGL中使用可编程和固定管道功能(Using both programmable and fixed pipeline functionality in OpenGL)
  • 将任何用户输入重定向到单独的底层程序(redirect any user input to a separate underlying program)
  • 编辑文本不能正常工作android(Edit texts not working properly android)
  • “user_denied”Facebook应用页面上的Facebook用户区域设置(Facebook user locale on “user_denied” facebook app page)
  • 在大图像中找到小的部分透明图像的坐标(find coordinates of small partially-transparent image within a large image)
  • 我如何在cakephp 3.1中获得完整的相对路径?(How i can get full relative path of image in cakephp 3.1?)
  • 如何保存拖动标记的新本地化?(How to save new localization of dragged marker?)
  • MySQL UPDATE vs INSERT和DELETE(MySQL UPDATE vs INSERT and DELETE)
  • 在执行查询之前,在SQLAlchemy模型中将datetime转换为unix时间戳?(Convert datetime to unix timestamp in SQLAlchemy model before executing query?)
  • OpenCL与OpenGL互操作的优势(Advantage of OpenCL interoperability with OpenGL)
  • 如何解析用点和等分隔的数据然后添加到listview(How to parsing data from delimited with dot and equal then add to listview)
  • 带调试输出的X3解析器段错误(BOOST_SPIRIT_X3_DEBUG)(X3 parser segfaults with debug output (BOOST_SPIRIT_X3_DEBUG))
  • 将文件夹名称添加到fgrep结果(Add folder name to fgrep result)
  • 在MySQL中加载一个表是非常慢的(Loading one table in MySQL is ridiculously slow)
  • 如何将JSON放入PHP变量?(How do I put JSON into a PHP Variable?)
  • 如何绕过Microsoft.Speech.Recognition中的不流畅?(How to bypass disfluencies in Microsoft.Speech.Recognition?)
  • 原点的最后一行是什么?(What is the last row of an origin for?)