Merge Two Databases In One Database.

Hi,

I want to share knowledge that we have the abality to merge the two databases in one database. As if your site is already working with data base with out login page. And you are using asp.net built in funtion to create login page there will be a new database will automatically generated with the name of "ASPNETDB.MDF". you will check it in machine.config. If you want to get its data in old one database you only open sdk dos promt and write aspnet_regsql.exe and press enter. A wizard will open for you. in first two wizard you click next without changing it. and in the 3rd page you will enter the database name in which you want to write this ASPNETDB.MDF data. and in the final page you click finished button and close the sdk dos promt.

You should go on web. config file and modify the code for example.<connectionStrings>

<add name="wordexpress" connectionString="server= localhostsqlExpress;Database=wordexpress;Integrated Security=True"providerName="System.Data.sqlClient" />

<remove name="LocalSqlServer"/>

<add name="LocalSqlServer" connectionString="server= localhostsqlExpress;Database=wordexpress;Integrated Security=True"providerName="System.Data.sqlClient" />

</connectionStrings>

And then check your old database you will see that there is new 11 table added.

My question is that I cannot get these table in my old database. I have working with the same procedure. Can any one tell me if there is any mistake from my side.

 

Naveed Baig.