1

I'm hoping to use an SSDT database project alongside a migration-based database development tool like grate. The idea here would be to use migration scripts as the source of truth for the database schema, but to import into the database project to generate the more complex change scripts (for which project compilation would provide extra confidence). I'm hoping that I could script a process that runs migration scripts, then recreates/updates the database project, so that it's automatically kept in sync.

Is it possible to programmatically import from a database into a new (or existing) SSDT database project? I'm looking to do something equivalent to importing into a Database Project using SQL Server, but programmatically.

I don't think that it is:

The most recent answer is nearly 6 years old, and I'm not certain that the situation hasn't changed since then. It would be nice to have a definitive answer either way.

mattg
  • 11
  • 1
  • You can extract dacpac automatically, but I'm pretty sure that importing that into the project in automated way is not possible. – Dmitrij Kultasev Oct 19 '22 at 11:34
  • Thanks for commenting Yes, I suspect that's true. My assumption is that it's not possible, but I'd like to be certain. – mattg Oct 19 '22 at 14:12
  • @DmitrijKultasev I think maybe I misinterpreted your comment as having less confidence than you meant to imply. Having re-read your comment, I think that when you say "you're pretty sure" you mean you're almost certain. Is that right? – mattg Oct 19 '22 at 14:41
  • Yes, I haven't followed news this year, but there was no such solution at the end of 2021 – Dmitrij Kultasev Oct 21 '22 at 04:57

0 Answers0