ER modelling and “Database project”


I have tried out the “Database Project Type” for some of my database projects now, and I have found a preferred way on how I will approach future projects. Overall I think the solution explorer for a “Database Project” is too heavy to be able to start from scratch when a new database shall be made. Essentially, the programming model is normal scripting of the schema with tables, views, constraints, keys and so on. For me that is enjoying the possibility to work in a graphical environment like Visio and Database Diagrams would like to continue with this.

I normally use the Visio “Database Model Diagram” and often start with a reverse engineering of an existing database. Make changes in the diagram and use the forward engineering plug-in (described in this post) to create a database script that I can import into a new database project. This process will help me alot when create a new database from scratch, remodelling an existing database when get a good starting point for any new projects.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s