1 / 20

Mastering Database Management with RoundhousE: A Comprehensive Guide

Discover how to streamline your database management with RoundhousE, a powerful tool that simplifies migrations, versioning, and auditing. In this session led by Rob "FerventCoder" Reynolds, a C# MVP and Technical Lead, we delve into best practices for maintaining database consistency across environments, handling changes effectively, and ensuring your audits are thorough. Whether you're using SQL Server, Oracle, MySQL, or other platforms, RoundhousE can adapt to your needs. Join us to learn how to make database management easy and efficient!

vivek
Télécharger la présentation

Mastering Database Management with RoundhousE: A Comprehensive Guide

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Professional Database Management with RoundhousE!

  2. Before We Start • Questions – ask, but we may have to hold until end • http://projectroundhouse.org

  3. Rob “FerventCoder” Reynolds • C# MVP • Technical Lead for Heartland Crop Insurance • Active in OSS • Chuck Norris Framework • NuGet core team member • Various contributions to other projects • ferventcoder – twitter, gmail, you name it • ferventcoder.com / Devlicio.us • Recently given a new nickname: Inspector Gadget

  4. Past/Present • Worked w/ a database of some sort • How do you get changes? • Does it get any easier?

  5. Why do we need migrations? • Things invariably will change • Very few systems require no changes over the years

  6. Different Environments 1. Local (Developers) 4 . Production (Users) 2 . Test (Testers) 3 . Staging (Users/Proxies)

  7. Let’s talk about Pain • How do you apply a database change one time? • How do you keep all environments in sync? • Databases change – updates with new/changed tables, views, stored procedures, etc • Databases store data • Deleting data is bad. Don’t be a bad monkey!

  8. What is RoundhousE? • And why is kicking my database a good thing? • It’s easy to use • Make your auditors smile • Version your database • It’s environment aware • And that’s not even the cool stuff yet.

  9. What does it work with? • SQL Server 2000/2005/2008/Express • Oracle • Access • MySQL (just added, still dark) • Soon: • PostgreSQL • SQLite

  10. ChuckNorris • Suite of tools to help make developers more productive by scaffolding frameworks, etc • RoundhousE makes db migrations easy • http://groups.google.com/group/chucknorrisframework

  11. Easy to use • One required parameter (/d) for database • Folder format • Comes with samples • Documentation is solid

  12. Make Your Auditors Smile • Audit logging – who did exactly what when? • Auditing changes by capturing all scripts and logs each time

  13. Version Your Database • 1.0.0.0 – version? • “What version is your database on?”

  14. Environment Awareness • Scripts meant for an environment will only run in that environment • Default is “LOCAL”

  15. Conventions / Customizable • The cool stuff • Don’t like RoundhousE as the schema? Change it • Don’t like the “up” folder? Change it • Don’t like xxxxx? Change it

  16. Integrate into development • Also the cool stuff

  17. How do I get RoundhousE? • gem install roundhouse • cinstroundhouse • nuget install roundhouse (for your local project) • Source (git / svn) – projectroundhouse.org • Old fashioned download – projectroundhouse.org

  18. Asking questions • Documentation • https://github.com/chucknorris/roundhouse/wiki • Chuck Norris Framework • http://groups.google.com/group/chucknorrisframework • @Roundhouse_DB • #roundhouse_db • @ferventcoder

  19. Questions?

  20. http://ProjectRoundhousE.org • http://ferventcoder.com | ferventcoder@gmail.com | Twitter: ferventcoder

More Related