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
1
vote
1 answer

What causes NuGet to restore package to slightly different folder structures?

Visual Studio 2019 I have a .NET Core solution that needs to reference a single .NET Framework package just for the purposes of expanding the package contents into the packages folder so that some tools are available. In my .csproj I have this line…
BaltoStar
  • 8,165
  • 17
  • 59
  • 91
1
vote
1 answer

TeamCity SQL Project : Microsoft.Data.Tools.Schema.SqlTasks.targets was not found

TeamCity I have a TeamCity project with a .NET CLI (dotnet) build step for a Visual Studio Solution ( .sln ). The solution includes a SQL Project ( .sqlproj ). Running this build-step gives error : [build]…
BaltoStar
  • 8,165
  • 17
  • 59
  • 91
1
vote
1 answer

Using RoundhousE with dll File

I've decided to use RoundhousE for my database. Now there are three ways to use this tool. With MSBuild, a DLL File or the console application. I found some documentations how to use the MSBuild variant and I know how to use the console application…
Canox
  • 557
  • 1
  • 7
  • 20
1
vote
3 answers

How can I force files in my project so that they always copy to output directory

I am using a visual studio c# library project to contain static resources that are needed as deployment artifacts. (in my case SQL files that are run with a combination of RoundhousE and Octopus deploy). By convention all files in the project must…
Rob Bird
  • 3,764
  • 2
  • 28
  • 38
1
vote
4 answers

How do I make a database backup and have it stored locally?

So here's the challenge. I need to use C# to back up a database locally from a remote database server and the only share we have is \\computer\c$. If the answer is to back up to a location on the remote database server and then copy that local,…
ferventcoder
  • 11,952
  • 3
  • 57
  • 90
1
vote
2 answers

Staging database version changes in development with RoundhousE

EDITED: from original as frankly it was a poor question first time around.... We have a batch script called DEV.DBDeployment.DropCustomCreate.bat, as the name suggests this drops and creates our db from a fresh, a useful tool in Dev but we don't…
Lloyd Holman
  • 974
  • 6
  • 7
1
vote
1 answer

Is using Entity Framework code first purely for database migrations ok?

I'm currently using RoundhousE to manage my database migrations and this works really nicely. I have been looking into various migration creation technologies like FluentMigrator and some others. The possibility for errors though seems really high…
Neil
  • 5,179
  • 8
  • 48
  • 87
1
vote
1 answer

connecting as SYSDBA using roundhouse

I want to connect as sysdba using roundhouse, already tried conn.ConnectionString = "Driver={Microsoft ODBC for Oracle};SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521))(CON NECT_DATA=(SERVICE_NAME=orcl)));uid=scott;pwd=tiger**;as…
user009
  • 11
  • 1
0
votes
0 answers

How to skip one-time scripts whose entry is already present in RoundHouse.ScriptsRun table?

We are in process of setting up ETL and Business Objects for our new client. The database strcuture for this new client would be same as of our old client. So, we have copied the database structure of old client. We have also copied the entries/data…
Chinmay Karanjkar
  • 1
  • 1
0
votes
0 answers

unable to create database in postgresql using round house tool

I have postgresql localhost database installed in to my machine and try to create table using round house tool, I'm getting the below error RoundhousE encountered an error. System.Data.SqlClient.SqlException (0x80131904): A network-related or…
shivu
  • 1
  • 1
0
votes
0 answers

RoundhousE Migration Fails On Valid SQL On SQL Server

I have a mature code-base with a set of SQL migration scripts. We run the migrations to update or create the database using RoundhousE via a Powershell script. Until recently these migrations were running successfully, however now I am getting an…
Chris B
  • 5,311
  • 11
  • 45
  • 57
0
votes
0 answers

Run RoundHouse scripts based on object dependencies

Currently we have been using RoundHouse for deploying of database scripts. The scripts are organised into folders for views, functions, up, and stored procedures. Each script creates or alters a single object Everything has been working for many…
Andez
  • 5,588
  • 20
  • 75
  • 116
0
votes
1 answer

ZombieCheck Error when running RoundhousE

I'm trying to do a release of our web app (using tfs to deploy to Azure), but I keep getting an error that I can't make any sense of: 2018-07-10T07:07:27.7518609Z RoundhousE encountered an error. You were running in a transaction though, so the…
ShIxtan
  • 71
  • 1
  • 6
0
votes
2 answers

Migrate existing SQL Server database using roundhouse?

I have a SQL Server database with data. I'm planning to implement Roundhouse in my project. How can I migrate existing table schema into Roundhouse table ?
Prabhu
  • 647
  • 2
  • 9
  • 18
0
votes
1 answer

Can we create a view which refers to a view which is not exist at that point of time?

We have a view definition which internally uses other 5 views. When we use a RoundhousE to execute the database scripts, these view scripts are getting executed in alphabetical order. Hence out of these 5 views, which are used inside the main view,…
Rajesh Bhat
  • 791
  • 3
  • 8
  • 20
1
2
3