Search code examples
sql-serversql-server-data-tools

How to create SSDT project from existing database?

I have an existing SQL database and I need to add an SSDT project to the project I am working on. What would the correct way to add the tables and stored procs from the existing database to an SSDT project?

Solution

  • Use Schema Compare with your existing database to populate your SSDT project. I think you will find that it is really rather simple.

    Schema Compare uses two connections (connection strings) to compare two different databases, or in your case one connection string to connect to the existing database (source) and then you choose your database project project as the other (target).