SQL Database code comparison

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » SQL Database code comparison

SQL Database code comparison

Rate Topic

Display Mode

Topic Options

Author

Message

be05x5

Posted Wednesday, February 27, 2013 1:21 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, April 19, 2013 12:18 PM
Points: 2, Visits: 7

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

SQL Pizza

Posted Thursday, February 28, 2013 1:05 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:14 AM
Points: 116, Visits: 293

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

TheSQLGuru

Posted Friday, March 01, 2013 6:23 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 12:01 PM
Points: 3,582, Visits: 5,130

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

be05x5

Posted Friday, March 01, 2013 10:46 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, April 19, 2013 12:18 PM
Points: 2, Visits: 7

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

Sachin Nandanwar

Posted Friday, March 01, 2013 11:56 PM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, May 16, 2013 7:14 AM
Points: 238, Visits: 2,341

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 »

Permissions