I have run the Database Publishing Wizard and have a .sql file. When I run this, does it create a whole new database? I have a database where I have my data for this project. Can I just add the ASPNET tables to it so I can have all my table for the project in one database? If I do another project won't it want to look in the "default" that would be created here even though they are not related?

Hi there,

Not 100% sure (can't check at the moment) but I don't think it creates the database; just the tables, view and stored procedures and the data.

Take a look at page 725 and further to learn how to change the connection string so it points to a different database.

Also, take a look at page 771 to learn more about aspnet_regsql to configure databases for the app services.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!