0

I have two database schema. I need to generate the script consisting of the difference. How do I do this?

Basically, I had original schema that I modified. So I need the script for what changed. Which tables got dropped and relationships are broken etc...

P.S. I do not have red gate.

Improve this question
4
  • red-gate.com/products/sql-development/sql-compare Commented Aug 8, 2013 at 17:55
  • Unfortunately I do not have red gate. Commented Aug 8, 2013 at 17:56
  • Do you have Visual Studio 2010+? Commented Aug 8, 2013 at 17:59
  • Yes, I have visual studio professional 2012. Commented Aug 8, 2013 at 18:00

1 Answer 1

Reset to default
1

Use the Schema Compare feature in Visual Studio:

Main Menu --> SQL --> Schema Compare --> New Schema Comparison

And go from there...

It may prompt you to download the SQL Server Data Tools from here if you don't already have it.

Note: I am no sure if this works in the Professional Version. It's certainly available in the Ultimate edition.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

visual studio professional 2012 does have this tool. I had to add Data Tools recommended above.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.