Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

It seems AdeptSQL Diff is not compatible with SQL Server 2012 (at this time). And it is my preferred tool for deploying changes. I realize this is a shopping list but I hope SE won't mind.

I am wondering what are the best alternatives out there and wanted to query the DBAs.

Currently I am evaluating RedGate SQL Compare. It doesn't include data comparison (separate product) though it does generate deployment scripts which is nice. Just want something quick and painless for launching schema changes to production servers. What do you recommend. Thanks!

share|improve this question
1  
Redgate compare = schema, data compare = data. I highly recommend both. –  Eric Higgins Sep 10 '12 at 20:39
add comment

1 Answer 1

up vote 0 down vote accepted

ApexSQL Diff supports SQL Server 2012. Haven't tested it on SQL Server 2012, but it works fine on 2008

share|improve this answer
    
We tested it yesterday and it wasn't able to pick up differences in SPs or Tables between 2008 & 2012. Also their website doesn't list 2012 as one of supported servers. Yes, it does work for 2008 –  Dina Sep 12 '12 at 14:03
    
I had no problems with 2012. Have you checked these pages on their website: apexsql.com/sql_tools_diff_features.aspx –  Carol Baker West Sep 12 '12 at 14:10
    
Ah sorry! I read Adept instead of Apex. Apologies. –  Dina Sep 16 '12 at 14:23
    
Dina, no problem :) –  Carol Baker West Sep 16 '12 at 19:35
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.