tag:blogger.com,1999:blog-12773241.post115452603507862111..comments2023-09-10T06:42:22.288-07:00Comments on Matt Adamson: Continuous Integration of database scriptsMatt Adamsonhttp://www.blogger.com/profile/12131418412061331395noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-12773241.post-52198258502861791972011-05-04T00:53:12.859-07:002011-05-04T00:53:12.859-07:00Hi,
I suggest you have a look at the open source ...Hi,<br /><br />I suggest you have a look at the open source neXtep designer project. It is a database development IDE initiative aiming at automating the integration and deployment phazes of a database application.<br /><br />From the latest release, neXtep offers a command line tool allowing you to drive the build of your database from simple command line calls. You could therefore easily wire this with your integration server. <br /><br />We need feedbacks, use cases and suggestions about this new feature. That would be great if you could have a look and tell me what you think.<br /><br />Here is the link to the project :<br />http://www.nextep-softwares.com<br /><br />Kind regards,<br />ChristopheChristophe Fondaccihttps://www.blogger.com/profile/12646495387723551950noreply@blogger.comtag:blogger.com,1999:blog-12773241.post-60202922990671721232011-04-20T19:34:47.377-07:002011-04-20T19:34:47.377-07:00I am not sure if this helps but I have been using ...I am not sure if this helps but I have been using (N)ANT to build database scripts from SCM branches for some years.<br /><br />It is pretty straight forward to produce a consolidated file with the table/procedure/UDF etc... changes. I go further and produce independent scripts for Production and UAT so that I can apply specific changes for our test environment.<br /><br />What I would like to do next is expand the build process to include database unit test cases.Samhttps://www.blogger.com/profile/06479843171683467026noreply@blogger.comtag:blogger.com,1999:blog-12773241.post-89596535136193192372009-03-02T05:48:00.000-08:002009-03-02T05:48:00.000-08:00Matt - I know this post if a bti old, but relevant...Matt - I know this post if a bti old, but relevant to something I'm doing. I've been using CC.Net to do application builds and unit tests for a few years now. Now, I'm looking at taking it that step further and integrating my database scripts. Our environment performs a weekly refresh of our database schema from our production environment. I need to then apply any script changes to this older version of the database. Any thoughts you could throw out that could help in my planning of this process in using CI?Anonymousnoreply@blogger.com