how to combine both the db's into one

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?

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

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

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

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>

Thanks

/Kadji

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

Thanks kadji

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

Cheers

Ujval