Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Apr 24, 2012 06:08 AM by eralper
Apr 24, 2012 05:06 AM|LINK
I have developed a website in C# and SQl server 2005, now I need a clone website with different domain name. But I want to use the same database in both sites. Means, if I update the website from any of the admin, the changes should be replicated in both
sites immediately. The website is hosted at HostGator.
Please suggest me best possible solutions for this.
Apr 24, 2012 05:13 AM|LINK
Just set your connection strings for each site, and connect .
You can use a single DB server.
Apr 24, 2012 06:08 AM|LINK
Some free applications support such configurations. What is special there is they keep a unique id value for each site.
And when you connect from website1.com they read data from a table with that unique id. So you need to alter your database tables and add a new column to seperate your data. And you need to add a new parameter to your stored procedures to read the data for
the current website.
SAP tables also keep such data called ClientId in every table.
But it is also possible to seperate your applications databases. Of course if it is possible to have two databases on your webhost