I need some step by step instructions with MSSQL Driven WebApp.
I think it is a couple steps solution however I would need some help with it, please:
I have a Virtual Dedicated Server with Windows server 2008 R2 and SQL Server Management Studio 2008 R2 and it is accessible with Remote desktop connection.
There is a web based app which is fully connected to MSSQL database on the same server. The app is fully functional, no issues with that. The website is built in .NET (I think 3.5 or 4.0).
Database name: ABCApp
User which is used for connection: sa (system admin)
The connection string is
<add name="ABCApp" connectionString="Data Source=(local)\SQLEXPRESS;Initial Catalog= ABCApp;User ID=sa;Password= ABCAppPassword" />
I would like to create a copy of the ABCApp and a copy of the LIVE database for a parallel (beta) development. The copy has to be 100% disconnected from the live version.
I created a separate hosting and placed all the files on the same Virtual Dedicated Server already and it is working perfectly, however it uses the LIVE database.
Since I have no experience with MSSQL I would like to ask what would be the next step by step instructions to make the BETA version of ABCApp run with a BETA version of the database (which needs to be created and connected to the BETA version of ABCApp
If you need any additional info please let me know.
Thank you for your help.