![]() When I right clicked on publish and chose option to generate script, only pre and post deployment scripts were in the main script.Moreover, where is the database creation script.But everytime I am building the project it does not get deployed - only showing build succeeded.INSERT INTO dbo.MovieActors (Id, MovieID, ActorID) INSERT INTO dbo.Movies (Id, Name, ProducerId) ![]() INSERT INTO dbo.Producers (Id, Name, Sex) Post-Deployment: INSERT INTO dbo.Actors (Id, Name, Sex) int FOREIGN KEY REFERENCES Producers(Id)Īnd I have also added pre-deployment (for deleting existing data) and post-deployment scripts (for seeding initial data). Here is the structure of my project :īasically, I want 4 tables, so I have added 4. I want to create a SQL Server database project where a new database is created.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |