February 27, 2013 at 1:21 pm
Good Day all,
I am in a process of setting up a full blown test and development environment. We are primarily an ASP.NET C# shop. I will start using Team Foundation Service for my code and source control. I am wondering on a good approach to manage SQL changes such as:
Table changes,
Stored procedure changes,
Function changes
Is there software that can track changes between 2 databases? I understand that you can track changes within TFS but I have some doubts about that…
Anyways any input is greatly appreciated.
February 28, 2013 at 1:05 am
There are severel ways to accomplish this :
- using a database trigger, triggering if any DDL-Statements get fired
- automatic scripting of your database objects to files which you compare
- use redgate tools : SQL Compare (you can also automize it), SQL Source Control
- there are also free tools out there
- like I Did...write your own solution (f.e. web interface for change management, users can change nothing...database trigger forbids all DDL)
- afaik there's a standard report named "schema changes history"
Can't remeber more opportunities, but I know there are more. Also checkt this link[/url] and the read furthers.
Just tell me a bit more about your special intention and I can help you better.
Greetz
Query Shepherd
March 1, 2013 at 6:23 am
ApexSQL and Red-Gate both have very good schema (and data) change management products. I there are some free alternatives out there but in this case believe you get what you pay for. Go with one of the above options.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
March 1, 2013 at 10:46 am
Cool. Thanks for the information. I have checked out these tools and they seem very good.
Basically I don’t have a DBA. We build asp.net apps and constantly change stored procedure parameters or functions. This prevents us from testing in development since we don't have dev DB set up yet.
I am working on setting up a full development and test environment and was looking to easily move from development to testing to production. So I will use team foundation service for my code and source control and need a way to move the SQL code into these as well.
Thanks.
March 1, 2013 at 11:56 pm
If you are already using Visual studio you can use GDR functionality that comes up VS 2008/2010 database edition.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply