How to Convert .dbproj to .sqlproj programmatically using C#

Question

Hi, How do i convert .dbproj to .sqlproj programmatically using C# Code Please help me

Prakash Kumar · Answer

To convert a project Open a SQL Server 2005 or 2008 Database Project. The Convert to SQL Server Database project wizard automatically opens. Select Convert to SQL Server Database project and click OK . Keep the default setting to backup existing files checked. A conversion report is automatically generated, listing all files that have been converted. Click the + sign next to the project filename to read more information about the conversion process. Notice that in Solution Explorer , project file, property files and schema objects are all converted. To change a project’s target platform Right-click your newly converted project in Solution Explorer and select Properties to access the Project Settings dialog box. Select any of the SSDT-supported platforms in the Target platform dropdown list. Refer the below link, https://msdn.microsoft.com/en-us/library/hh272689(v=vs.103).aspx http://blog.tentaclesoftware.com/archive/2013/02/11/visual-studio-2010-and-2012-sqlproj-interoperability.aspx http://geekswithblogs.net/80n/archive/2012/09/12/vsdb-to-ssdt-part-1--converting-projects-and-trimming.aspx

How to Convert .dbproj to .sqlproj programmatically using C#

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (1)