Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

gitignore file for SQL Server project: SSIS / SSAS / SSRS?

There's a git ignore pattern for all the Visual Studio projects on GitHub: gitignore/VisualStudio.gitignore. But I'm working specifically for SQL Server Business Intelligence solution in VS, and it seems that files like *.ispac are not ignored. Is there any more specific pattern available for these projects ?

  • SSIS
  • SSAS
  • SSRS
like image 608
Mincong Huang Avatar asked Jun 29 '16 08:06

Mincong Huang


People also ask

How do I add a Gitignore to an existing project in Visual Studio?

Open Visual Studio and the solution needing an ignore file. From the top menu select Git > Settings. The above will open Visual Studio's Options with Source Control > Git Global Settings selected. From the list on the left select Git Repository Settings and then click the Add button for Ignore file.

How do I Gitignore a file?

If you want to ignore a file that you've committed in the past, you'll need to delete the file from your repository and then add a . gitignore rule for it. Using the --cached option with git rm means that the file will be deleted from your repository, but will remain in your working directory as an ignored file.

How do I use Gitignore in Visual Studio?

Visual Studio automatically creates a . gitignore file in your repo when you create a new repo for your project. You can edit your . gitignore file for your repo by going to the Settings view in Team Explorer, then selecting Repository Settings.

How to add gitignore in Visual Studio 2015?

In Visual Studio 2015 Team Explorer > Local Git Repositories > Project > Settings > Git > Repository Settings > Ignore & Attribute Files.You can add .gitignore file with items should be ignored in visual studio solutions by default.

Where does gitignore store the database files?

Since your project may be a subfolder of your solution, and the .gitignore file is stored in the solution root, this actually won't touch the local database files (Git sees them at projectfolder/App_Data/*.mdf ). To account for this, I changed those lines like so:

Is there a Git ignore pattern for MS SQL Server business intelligence?

There's a git ignore pattern for all the Visual Studio projects on GitHub: gitignore/VisualStudio.gitignore. But I'm working specifically for SQL Server Business Intelligence solution in VS, and it seems that files like *.ispac are not ignored.

How do I ignore a git repository in Visual Studio?

From the top menu select Git > Settings. The above will open Visual Studio’s Options with Source Control > Git Global Settings selected. From the list on the left select Git Repository Settings and then click the Add button for Ignore file.


1 Answers

I did some googling this morning on this and I found the following file. It looks pretty complete so I will give it a try. The *.ispac files are in the bin directory so they should be ignored anyway thanks to the rule for ignoring bin and obj.

https://www.gitignore.io/api/visualstudio

like image 61
RobbZ Avatar answered Sep 21 '22 21:09

RobbZ