VS 2010 Database Project deploy sql scripts

Question

I am working on a sql database project in VS 2010. I know how to synchronize the schema, but what I want is this: 1. I have some data sql scripts that inserts data into some tables. 2. I want to when I click Deploy on the DB project to automatically deploy those data scripts and execute them on the sql server.

How to do this?

Thanks

David Atkinson · Accepted Answer · 2010-08-04 22:16:10Z

1

You'll need to put the INSERT statements into a post deployment script.

answered Aug 4, 2010 at 22:16

David Atkinson

5,9382 gold badges30 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VS 2010 Database Project deploy sql scripts

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related