how to combine both the db's into one RSS

• • Reply
  

  ujvalv

  Member

  25 Points

  5 Posts

  how to combine both the db's into one

  Jul 20, 2006 09:31 AM|LINK

  Hi

  I am having a pricing problem with hosting provider.[:'(]

  So i will have to combine both these db's into one ! (APNETDB andCLASSIFIEDSDB)

  can this be done.

  if so can any one tell me all teh changes which has to be done in teh web.config file and other files?

   

• • Reply
  

  justin0501

  Member

  705 Points

  138 Posts

  Re: how to combine both the db's into one

  Jul 20, 2006 12:07 PM|LINK

  You just need to run the aspnet_regsql like you did to create the aspnet db before but point it to the server/database you want to use. If you cannot run that utility I'm sure the host can.

  In your web.config change your connection strings to point to your database

• • Reply
  

  Kadjiokou

  Participant

  1432 Points

  326 Posts

  Re: how to combine both the db's into one

  Jul 20, 2006 02:27 PM|LINK

  Hi,

  I have repeatedly done this on hosted databases. As the previous post suggest, run the program on your CLASSIFIELDDB.

  You will need to provide "servername" and "login credentials" obtained for your hosted CLASSIFIELDDB. This can really work.

   

  Your web config should then contain something similar to the below:

   

  <connectionStrings>

  <add name="classifiedsConnection" connectionString="Data Source=dbserver  ;database=ClassieFieldDB; User Id=username; PWD=password" providerName="System.Data.SqlClient"/>

  <remove name="LocalSqlServer"/>

  <add name="LocalSqlServer" connectionString="Data Source=dbserver ;database=ClassieFieldDB; User Id=username; PWD=password" providerName="System.Data.SqlClient"/>

  </connectionStrings>

   

  Thanks

  /Kadji

   

• • Reply
  

  ujvalv

  Member

  25 Points

  5 Posts

  Re: how to combine both the db's into one

  Jul 20, 2006 02:32 PM|LINK

  Thanks kadji

  This issue is almost resolved now as i am moving to another hosting provider

  Cheers

  Ujval