{"id":3243,"date":"2012-01-05T13:46:01","date_gmt":"2012-01-05T11:46:01","guid":{"rendered":"https:\/\/ingmarverheij.com\/?p=3243"},"modified":"2012-01-05T17:24:13","modified_gmt":"2012-01-05T15:24:13","slug":"reverse-and-forward-engineering-database-in-visual-studio-2010","status":"publish","type":"post","link":"https:\/\/ingmarverheij.com\/en\/reverse-and-forward-engineering-database-in-visual-studio-2010\/","title":{"rendered":"Reverse and forward engineering databases in Visual Studio 2010"},"content":{"rendered":"\n

\"\"In a previous post<\/a> I\u2019ve described how you can reverse and forward engineer a database from a Microsoft SQL server to (and from Microsoft Office Visio 2010. But what if you\u2019re using Typed Datasets<\/a> in Microsoft Visual Studio?<\/p>\n

Same as with Visio, reverse engineering an existing database from a SQL database is built-in and therefore fairly easy. So a best-practice is to design the database model in Visio, forward engineer it to a SQL database and import it in Visual Studio. <\/p>\n

If you want to forward engineer a Microsoft ADO.NET compatible DataSet Schema File (XSD)<\/em> to a (Microsoft SQL) database you can use the XSD2DB<\/a> tool created by Alexsis Smirnov<\/a>.<\/p>\n

In this blog post I will demonstrate how to reverse engineer a database from Microsoft SQL server, and how to forward engineer a XSD back to a Microsoft SQL server.<\/p>\n

<\/p>\n

How to reverse engineer a database from Microsoft SQL to Microsoft Visual Studio 2010<\/h2>\n

Start Microsoft Visual Studio 2010 and create a new project. For this example I’ll be using a Visual Basic Windows Forms Application, but the procedure is the same for other projects.<\/p>\n

 \"\"<\/a>\"\"<\/a>\"\"<\/a><\/p>\n

Rightclick on the project and add a new item (Ctrl+Shift+A). Search for \u2018DataSet\u2019 in the \u2018Search Installed Templates\u2019 on the right (name the dataset) and create the item.<\/p>\n

\"\"<\/a>\"\"<\/a>\"\"<\/a><\/p>\n

Now expand the Server Explorer (if the Server is not visible, click on View > Server Explorer), right click Data Connections and add a Data Connection. In the \u2018Add Connection\u2019 wizard specify the details of the connection like the server name (not localhost or 127.0.0.1), credentials and database name.<\/p>\n

\"\"<\/a>\"\"<\/a>\"\"<\/a>\"\"<\/a>\"\"<\/a><\/p>\n

Now you have added the connection to the database you can expand the database and the objects you wish to reverse engineer in your DataSet Schema File. This can easily be done by dragging-and-dropping the objects on the \u2018DataSet Designer\u2019.<\/p>\n

\"\"<\/a><\/p>\n

You now have successfully reverse engineered a SQL database to a DataSet Schema File in Microsoft Visual Studio 2010.<\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

How to forward engineer a DataSet Schema File from Microsoft Visual Studio 2010 to Microsoft SQL<\/h2>\n

Please first download and extract the XSD2DB<\/a> before proceeding..<\/em><\/p>\n

Open a command prompt and browse to the location where you\u2019ve extracted the XSD2DB tool. In my demo I\u2019ve extracted the files to C:\\Scripts\\XSD2DB.)<\/p>\n

\"\"<\/a><\/p>\n

If you wish to save a DataSet Schema File (XSD) to a Microsoft SQL server you should specify the following command:<\/p>\n

\"\"<\/a><\/p>\n

Where SQLServer<\/em> is the name of your SQL server, NewDB <\/em>the name of the new database and C:\\scripts\\DataSet1.xsd<\/em> the location of your DataSet Schema File (XSD).<\/p>\n

\"\"<\/a><\/p>\n

You now have successfully DataSet Schema File (XSD) to a Microsoft SQL server in Microsoft Visual Studio 2010.<\/p>\n

 \"\"<\/a><\/p>\n

<\/h4>\n

 <\/h4>\n

REMARK<\/h4>\n

Even if the database does not yet exist use the \u2013f [force] parameter, otherwise it will fail.<\/p>\n

If you\u2019ll try to connect to 127.0.0.1 ,or did not enable remote login connections to the server, you\u2019ll probably get the following error.<\/p>\n

System.Data.SqlClient.SqlException: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.<\/pre>\n
More information about this error can be found here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
In a previous post I\u2019ve described how you can reverse and forward engineer a database from a Microsoft SQL server to (and from Microsoft Office Visio 2010. But what if you\u2019re using Typed Datasets in Microsoft Visual Studio? Same as with Visio, reverse engineering an existing database from a SQL database is built-in and therefore […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[392],"tags":[391,389,173,673,388],"class_list":["post-3243","post","type-post","status-publish","format-standard","hentry","category-visual-studio","tag-forward-engineering","tag-reverse-engineering","tag-sql","tag-visual-studio","tag-xsd"],"_links":{"self":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/3243","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/comments?post=3243"}],"version-history":[{"count":4,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/3243\/revisions"}],"predecessor-version":[{"id":3247,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/3243\/revisions\/3247"}],"wp:attachment":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/media?parent=3243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/categories?post=3243"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/tags?post=3243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}