Add a 2'nd SQL2005 db

ADH · August 25th, 2007, 05:17 PM

I have in mind adding a 2'nd DB beside the original ASPNETDB. The new one should hold (only) all my specific appl. data.
1) Make sense?
2) Missed tried doing it. Could I get some advice what (VB2005) steps to take?
Thanks

ADH

Maxxim · August 25th, 2007, 06:08 PM

assume that you want to put your articles section in that second DB.

Follow this:
- Create a database on your "app_data" folder = "myDB_2"
On your connections section in web.config file:

Code:

<connectionStrings>
    <remove name="LocalSqlServer"/>
    <remove name="LocalSqlServerExtend"/>
    <add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf" providerName="System.Data.SqlClient"/>
    <add name="LocalSqlServerExtend" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|myDB_2.mdf" providerName="System.Data.SqlClient"/> 
</connectionStrings>

On your articles section in web.config file:

Code:

<articles pageSize="10" connectionStringName="LocalSqlServerExtend"  />

Good luck