Stack Overflow
Stack Overflow

Questions tagged [roundhouse]

RoundhousE is an automated database deployment (change management) system.

RoundhousE is an automated database deployment (change management) system that allows you to use your current idioms and gain much more. Currently works with Oracle, SQL Server (2000/2005/2008/Express), Access, MySQL, SQLite and PostgreSQL.There are future plans for other databases.

GitHub project: https://github.com/chucknorris/roundhouse

37 questions
5
votes
3 answers

What is the purpose of RoundhousE's RestoreRun mode?

According to the documentation, RoundhousE has 3 modes: Normal DropCreate RestoreRun The first 2 are clear, but I don't understand RestoreRun Mode and the benefit it offers in Production: Once you have gone to production, you switch from…
Joel Beckham
  • 18,254
  • 3
  • 35
  • 58
5
votes
3 answers

How to align RoundhousE to one-time scripts that have changed due to git line-ending normalisation?

I'm using RoundhousE to manage database migrations, and, due to bad legacy git config, the scripts have been committed to git with inconsistent line endings. I want to normalise these line-endings and, of course, in doing so RoundhousE detects hash…
SteveChapman
  • 3,051
  • 1
  • 22
  • 37
4
votes
1 answer

RoundhousE - Change login used by scripts scripts

I am trying to set up roundhouse deployment scripts. I am running into a little trouble with remote logins. We need to login with an sql account (not machine or domain - this is against MSSQL 2008R2 on Server 2008 R2 SP1) when creating the…
JMorgan
  • 805
  • 4
  • 11
  • 24
3
votes
1 answer

how to get Roundhouse to create db on second hard drive

I want Roundhouse to create the db on a second hd (not the C drive which it does right now). Is there any way in Roundhouse to do this ? Iam using sql server 2008 r2 express. I tried the -cds option for custom db creation but it gives an error…
Gullu
  • 3,477
  • 7
  • 43
  • 70
3
votes
1 answer

How to run a create index script using RoundhousE that depends on a sp in the correct sequence

Question on roundhouse. I have a script that calls a sp to figure out how much space is required to create an index. (we are using sql express which has max db size limit). Depending on how much space is left it deletes rows from a whole bunch of…
Gullu
  • 3,477
  • 7
  • 43
  • 70
3
votes
2 answers

Retrofit DB for use with RoundHouse

I'm looking into getting our db into source control. I can't find any info on the best way to retrofit existing dbs for use with rh. I can see the tables created should I just script those out and add them to our db and things will proceed from…
Raif
  • 8,641
  • 13
  • 45
  • 56
3
votes
1 answer

Can you let RoundhousE generate a script rather than executing it

Is there a way to get RoundhousE to generate a script file without executing it?
Koen
  • 3,626
  • 1
  • 34
  • 55
2
votes
0 answers

Cannot find data type 'UserDefinedType' despite being declared

The following script creates a stored procedure (mysproc.sql): /* A table type with 1 column (NVARCHAR(200)) of names */ CREATE TYPE [SchemaName].[NameList] AS TABLE( [Name] [NVARCHAR](200) ) GO ALTER PROCEDURE [SchemaName].[AlterNameAccess]…
MinistryOfChaps
  • 1,458
  • 18
  • 31
2
votes
2 answers

Postgres unencrypted keyword is no longer supported

When executing this postgres command: EXECUTE 'CREATE USER myuser WITH UNENCRYPTED PASSWORD ''my+password'''; I see the error: RoundhousE encountered an error. Npgsql.PostgresException (0x80004005): 0A000: UNENCRYPTED PASSWORD is no longer…
dahui
  • 2,128
  • 2
  • 21
  • 40
2
votes
1 answer

How to get values from an executed batch file

I'm trying to set up a barebones roundhousE setup, with a few touches. I'm trying to make the values used by roundhousE set in one central location, instead of each deployment batch script (which is a pain in the arse). However, when I reference the…
TechnicalTophat
  • 1,655
  • 1
  • 15
  • 37
2
votes
1 answer

What is available for Roundhouse Token Replacement?

We're using Roundhouse to deploy our databases and keep versions for SQL Server (2008+) I have a script which grants permissions and needs to have a username passed in. I know there is support for token replacement in Roundhouse, but the only token…
Robert Bratton
  • 435
  • 1
  • 5
  • 12
2
votes
2 answers

Can I create a brand new oracle db/schema with roundhouse?

I am a bit new to Oracle, having used mostly SQL, so some of my understanding of how oracle works and what users/connection strings to use might be wrong or non existant. I am trying to use roundhouse to create/manage an Oracle database. For now I…
Chaitanya
  • 5,203
  • 8
  • 36
  • 61
2
votes
1 answer

Infinite loop with Regex

We use the RoundhousE migration tool in one of our more SQL oriented projects. I have stubble upon a very strange bug A certain SQL function script (Sadly I cant supply the script because its the property of my customer) makes the Replace method of…
Anders
  • 17,306
  • 10
  • 76
  • 144
1
vote
2 answers

Which ORM frameworks will build and execute the SQL DDL for you?

Entity Framework Code First will build the database for you if it doesn't exist and structure it based on your mapping objects. I believe Roundhouse will do the same thing with Fluent Mapping files using NHibernate. Are there any other ORM's (or…
Ryan
  • 11
  • 1
1
vote
1 answer

Installing Oracle Client Tools - Docker, Roundhouse, Oracle

I am trying to get Roundhouse running from a Docker image where I have some Oracle scripts, but currently when I execute the rh command against my Docker image I get the following error: A type could not be created from the object you passed.…
user2760821
  • 109
  • 4
1
2 3