Tag: sql

How to commit on master branch DB related code?

What is the best practice for commiting DB related code on master branch? Is it OK to be incremental? Let’s say, in the first commit on master branch, there is version 1.0, with all create dbo, alter, … insert scripts and so on. On the second commit, there is only one script for all developers […]

Azure ASP.Net MVC database deployment best practice

We are a team of two developers, building an ASP.Net MVC app in Azure and are wondering what is the best way to go about setting up the database. We had been using a local db in the App_Data folder that attached to SQL Express, this seemed to be working fine until it came time […]

How to handle SQL Server CE in source control?

I’m curious for how we should handle SQL Server Compact in our Git source control. Everytime a developer changes data there is a binary merge conflict. Is there a way to keep development of this database in sync? If two developers pull down the source and modify the schema then one of them will lose […]

Cannot add SQL file to Git repository?

I need to add a SQL file to my Git repository. For some reason Tower or Git on the command line does not see that I’ve added a new file whenever it ends in .sql. I’ve tried creating an empty .sql and removed everything in .gitignore, but it still doesn’t see it. Any ideas?

Storing Drupal SQL in Git

I have a drupal site, and I am storing the codebase in a git repository. This seems to be working out well, but I’m also making changes to the database. I’m considering doing periodic dumps of the database and committing to git. I had a few questions about this. If I overwrite the file, will […]

Relational database backend for mercurial or git

What I like about fossil is that it uses plain old sqlite to store changesets, files, etc. I can use its command line tool to query the repository, but if I want something not supported by it, I can fallback to writing an sql query. Mercurial and git are more mature, they have more libraries, […]

SQL Stored Procedure: Conditional Return

Hi I want to create a simple stored proecudre which does the following: Psudocode @tempSelect = “SELECT * FROM Table” if (@Param is NULL) then exec @tempSelect else exec @tempSelect + ‘ WHERE id = ‘ + @Param + ‘ Is this method efficent? Thank you.

What's a good way (or tool) to version control a SQLite database (schema only)?

Can anyone suggest a good way (or tool) to version control a SQLite database (schema only)? I’m trying to version control a SQLite database and the only option I can find involves using GIT to version control the whole file, but I’m not interested in the data at this point, just the schema changes. Any […]

Tools to work with stored procedures in Oracle, in a team?

What tools do you use to develop Oracle stored procedures, in a team : To automatically “lock” the current procedure you are working with, so nobody else in the team can make changes to it until you are finished. To automatically send the changes you make in the stored procedure, in an Oracle database, to […]

SQL version control methodology

There are several questions on SO about version control for SQL and lots of resources on the web, but I can’t find something that quite covers what I’m trying to do. First off, I’m talking about a methodology here. I’m familiar with the various source control applications out there and I’m familiar with tools like […]

Git Baby is a git and github fan, let's start git clone.