Browse by Tags
All Tags »
Data Dude (
RSS)
I created a tutorial about working with the database project. For those of you who did not use the database project before and for those who want to learn a bit more, I recommend checking it out. The tutorial is attached to this post. Enjoy :)
Here is a bug I encountered during renaming operation in a database project. I had a procedure named sp_ a pp_GetUser and I tried to rename it to sp_ A pp_GetUser. Notice that the only different is with the capital 'A' at the app. Well, the IDE refused to accept it! It turns out that it does not recognize any change in the name when only changing lower case to upper case. The work around was to rename it to sp_ AA pp_GetUser and then renames it again to sp_ A pp_GetUser which is what I wanted to...
I was trying to understand if renaming stored procedure in the schema of the DBDude is affecting the entire solution. Let me explain it. Let’s say that in you solution you have a data access layer and a database project. The data access layer project references the names of the stored procedures that are defined in the database schema. I expected that renaming the name of a stored procedure using the refactor in the DBDude menu will result in renaming all the references inside the solution. This...
In one of my projects I had to initiate the deploy operation on my database project during the team build. Here is an article that describes how to just that. An important comment I would like to add is the fact that we need to manually change the .proj file. The link contains information about it, however to further emphasize it, here is the explanation: "The target connection and database are stored in the ProjectName.dbproj.user file, which is user specific and not typically checked in to version...
