Best way to use RoundhousE with an existing database

[Keith Bloom]

Hello,

I think RoundHouse is the best solution I have seen for managing
schema changes. Thanks for the effort and for the active support.

I have spent today extracting the schema from a legacy databases by
doing the following:

Put all the tables in to a file called 0001_BaseSchema.sql and put
this in the "up" folder
Exported the sprocs, views and functions and put them in the related
RoundHouse folder
Created a _BuildIInfo.xml file with the version number 0.0.0.0

This all works fine and I can deploy it to an empty database. It fails
though when I deploy it to an existing database. Understandable my as
the active database doesn't have any of the RoundHouse tables which
indicate the current version.

Is there a way around this though? I guess I would like to tell
RoundHouse that this is a baseline for an existing database and for it
to add the version tables.

Thanks, Keith.

[Rob Reynolds]

We are working on a folder that will only be run when creating new databases. You can thank Andy Davis for the great ideas in that respect. That said, it is still vaporware. It shouldn't be too hard to put in for sql server at least. :D
____
Rob
"Be passionate in all you do"

http://devlicio.us/blogs/rob_reynolds
http://ferventcoder.com
http://twitter.com/ferventcoder

--
You received this message because you are subscribed to the Google Groups "chucknorris" group.
To post to this group, send email to chucknorri...@googlegroups.com.
To unsubscribe from this group, send email to chucknorrisframe...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/chucknorrisframework?hl=en.

[Alan Howard]

Hi Keith,

After playing with RH I too thought it would be a good fit for an existing db. In my dev environment the db is rebuilt each time the app builds, and I followed a similar process to you to create the initial scripts. On test though, I backed up the existing db and then got RH to create a new db which includes the RH objects by running the DBDeployment bat file (there's no db drop step before the create on test) and just used SQL Data Compare to pipe my existing data across. RH just works from that point on. Bit of a fuddle but it's one-time pain.

Cheers,

Alan

 

[Keith Bloom]

Hi Alan,

Great.  It is good to hear a success story for using RH with a legacy database and I will try this out today.  Do you have a process for deploying the changes to production?

Thanks, Keith.

[Alan Howard]

I haven't set that up yet. My existing customers have their own remote databases but I'm moving them to a shared hosted db so I have the luxury of bedding in RH while I do this migration. I'll get RH running in the staging environment in the same way I've done it for test since that data is pretty much disposable. I'll probably set up the new prod environment in the same way and use RH going forward. For my existing customers and their individual dbs I might continue to rely on syncing schema changes using scripts & SQL Compare. Not ideal but probably less hassle than mucking around with live systems.

Let us know how you go :)

Alan

[Rob Reynolds]

Here is the enhancement for the one time scripts that are run only when a database is created https://github.com/chucknorris/roundhouse/issues/20

____
Rob
"Be passionate in all you do"

http://devlicio.us/blogs/rob_reynolds
http://ferventcoder.com
http://twitter.com/ferventcoder

[Rob Reynolds]

I just closed this enhancement as complete. 

Ways to get it:

1. Get latest and build.

2. TeamCity builds - http://teamcity.codebetter.com/viewType.html?buildTypeId=bt210&tab=buildTypeStatusDiv 

3. chocolatey - cinst roundhouse

4. ruby gems - gem install roundhouse

5. nuget install roundhouse

obviously the last three are going to be the quickest.

____
Rob
"Be passionate in all you do"

http://devlicio.us/blogs/rob_reynolds
http://ferventcoder.com
http://twitter.com/ferventcoder

[Keith Bloom]

Wow, thanks Rob. That isl exactly what I need.

Keith.

[Rob Reynolds]

Awesome! Soon we will have an official release available. Lots of items coming in here - 

• http://code.google.com/p/roundhouse/issues/list?can=1&q=Milestone%3DRelease0.8.5&sort=-closed
• https://github.com/chucknorris/roundhouse/issues?labels=v0.8.5&sort=created&direction=desc&state=closed&page=1

____
Rob
"Be passionate in all you do"

http://devlicio.us/blogs/rob_reynolds
http://ferventcoder.com
http://twitter.com/ferventcoder