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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We're working on migrating our database (~400 tables) from SQL 2008 R2 to SQL Azure. We're currently in the proof-of-concept stage, figuring out the process we'll be following. We have a process that we think is solid but I'd like to perform some validation diffs on both schema and data to confirm that we have a successful migration. I've never done this before with SQL Azure and am looking for a good tool to do this. I'd love if it's a free tool but we can pay for it if necessary. Ultimately, this is a one-time migration (we'll do it a few times but the real migration will only be done once).

Whatcha got?

share|improve this question

closed as off-topic by Paul White, dezso, Mark Storey-Smith, RolandoMySQLDBA, Jon Seigel Aug 2 '13 at 13:16

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White, dezso, Mark Storey-Smith, RolandoMySQLDBA, Jon Seigel
If this question can be reworded to fit the rules in the help center, please edit the question.

up vote 3 down vote accepted

Have you looked at SQL Server Data Tools? This has schema compare built-in, and can also identify objects and language constructs in your on-premises database that aren't compatible with Azure. It is free to download from Microsoft.

share|improve this answer
No, I didn't. I'll check this out. Thanks! – Jaxidian Jan 15 '13 at 16:09

Redgate SQL Compare appears to do this decently well. I'm still nailing down the settings to ignore certain thing (like NOT FOR REPLICATION) but at a glance, this seems like the tool I want.

share|improve this answer

Liquibase is another option. Open Source and the price is right. It's also useful for migrating between SQL Server and other Databases.

share|improve this answer

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