SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Database code comparison


SQL Database code comparison

Author
Message
be05x5
be05x5
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 Visits: 22
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.
Query Shepherd
Query Shepherd
Mr or Mrs. 500
Mr or Mrs. 500 (566 reputation)Mr or Mrs. 500 (566 reputation)Mr or Mrs. 500 (566 reputation)Mr or Mrs. 500 (566 reputation)Mr or Mrs. 500 (566 reputation)Mr or Mrs. 500 (566 reputation)Mr or Mrs. 500 (566 reputation)Mr or Mrs. 500 (566 reputation)

Group: General Forum Members
Points: 566 Visits: 454
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
Query Shepherd
TheSQLGuru
TheSQLGuru
SSC-Dedicated
SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)

Group: General Forum Members
Points: 33203 Visits: 8680
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
be05x5
be05x5
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 Visits: 22
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.
Sachin Nandanwar
Sachin Nandanwar
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1625 Visits: 2633
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search