1

I don't know much about SQL but this is what I want:

  1. Visually design an SQL database schema in Visual Studio
  2. Let VS generate a create script for this database
  3. Track modifications to my schema and automatically generate upgrade SQL scripts
  4. Generate entity classes I can use with WCF (without circular ref problems)

Is this possible somehow?

Im using Visual Studio 2010 Ultimate

Improve this question
1
  • What version of Visual Studio are you using? Both the year, and the feature set (Pro, Ultimate, Express)? Commented Oct 4, 2010 at 4:45

1 Answer 1

Reset to default
0

In know of no way in visual studio to do that. You can however use SQL server management studio. You can enable this by doing:

  • Click on "Tools"
  • Click on "Options..."
  • Click on "Designers"
  • Check the checkbox "Auto generate change scripts" as highlighted below

Also there are some external tools that enable this like:

http://www.sqldbtools.com/Tools.aspx?ProductId=1

I have used the program from the link above and it works like a charm.

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

Comments

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.