Question

Shadowfoxish on Mon, 09 Jan 2017 17:05:53


I have a developer on my team who has created a database project and is using a peculiar file and folder layout where all object types are in their own nested folders, with folders for each table. He's not around to ask, though I have a feeling he did this manually, but is there any way to reverse engineer an existing database into this sort of ultra-broken down project format?



Replies

Oscar_Wu on Tue, 10 Jan 2017 05:22:52


Hi Shadowfoxish,

>>He's not around to ask, though I have a feeling he did this manually

I agree with you, in my side, when I import a database from sql server, I cannot get the same structure as above screenshot. I think this need to be done manually.

>>but is there any way to reverse engineer an existing database into this sort of ultra-broken down project format?

If you want to import a database form the existing SQL Server, please refer to the following steps from the following link:

https://www.mssqltips.com/sqlservertip/2971/creating-a-visual-studio-database-project-for-an-existing-sql-server-database/

But we could not import the database based on the above structure (from your screenshot).

If I misunderstand your issue, please feel free to let me know :)

Sincerely,

Oscar

Shadowfoxish on Tue, 10 Jan 2017 19:26:46


Thanks. That's pretty much what I expected, just wanted to see if I missed something somewhere :)

Oscar_Wu on Wed, 11 Jan 2017 01:47:05


Hi Shadowfoxish,

Please remember to mark my above reply as answer, which could help others who have the same issue as yours. Thank you very much :)

Sincerely,

Oscar

Shadowfoxish on Mon, 16 Jan 2017 18:58:30


As a followup, I talked to the dev again; he says there was a way to do it in an older version of Visual Studio, so you'd reverse engineer with whatever version that was and then upgrade the project to latest.

Oscar_Wu on Wed, 18 Jan 2017 07:01:12


Hi Shadowfoxish,

Would you please share me which version of VS and SQL Server their used?

Sincerely,

Oscar

Shadowfoxish on Mon, 23 Jan 2017 16:20:16


Not 100%, but seems it was VS 2010

Oscar_Wu on Fri, 27 Jan 2017 03:19:51


Hi Shadowfoxish,

In my side, I installed VS2010, but I could not get the screenshot as you posted above.:(

Sincerely,

Oscar

Lennart A Jansson on Wed, 09 Jan 2019 11:03:11


A bit late perhaps, but better to be late than… Open the Sql Server in the SQL Server Object Explorer inside Visual Studio, right click on the database and choose Create New Project. In the dialog make sure you have the Folder Structure option marked as "Schema/Object Type". This will create a Visual Studio Database Project with the look that you are asking for...

I did a test in Visual Studio 2019 Preview to verify by importing AdventureWorks sample database and got the same result as you have