Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Database code comparison Expand / Collapse
Author
Message
Posted Wednesday, February 27, 2013 1:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 18, 2014 8:08 AM
Points: 6, Visits: 20
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.
Post #1424724
Posted Thursday, February 28, 2013 1:05 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, June 28, 2014 2:49 PM
Points: 116, Visits: 346
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 and the read furthers.

Just tell me a bit more about your special intention and I can help you better.


Greetz
SQL Pizza



sometimes you dont see the pizza for the toppings...
seek and ya shall find...
Post #1424939
Posted Friday, March 1, 2013 6:23 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:19 AM
Points: 4,320, Visits: 6,113
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 at GMail
Post #1425461
Posted Friday, March 1, 2013 10:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 18, 2014 8:08 AM
Points: 6, Visits: 20
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.
Post #1425639
Posted Friday, March 1, 2013 11:56 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 3:09 AM
Points: 314, Visits: 2,530
If you are already using Visual studio you can use GDR functionality that comes up VS 2008/2010 database edition.
Post #1425825
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse