Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
How to duplicate database using asp.net
December 26, 2013
I am developing one application where i am using SQL Server 2008. I kept one sample database with complete structure and i want when admin will create login for another user a duplicate database should be created automatically with the structure same as the sample database and the newely user will use the duplicate database.
Posted Date: December 28, 2013 Points: 20
We have option to Backup and Restore the DB in SQL. Take the Backup of master DB and Restore it in another DB. And Change the Connection string for New (Ordinary) User. Admin will take care of Master DB.
Posted Date: December 29, 2013 Points: 20
Thanks for the update. But can you tell me excately how it can be done. It will be really helpfull if you could provide any reference for this.
Posted Date: January 04, 2014 Points: 20
Here you may find example for Copy DB and changing the connection string dynamically.
Dynamic Connection string:
Posted Date: January 06, 2014 Points: 20
i will try and get abck to you if i need any help.
To post reply
Related Questions Related Questions
Restoring the Database
Image store in Database SQL SERVER
how can we update database thru datagrid
How to Encrypt & Decrypt password and stored in database..
How to change CrstalReport Database in Crystal Report
Programmatically attaching database
How to take Backup of Database at runtime... SQL-2005....
How to lock the database programetically using c# + windows application
Packaging Database Application
Latest Forum Questions From The Same Category
How do i get payment status in redirect page using bitpay?
Login with Facebook and Save details in database
Login with facebook account in my website
How to make a nested datalist control?
What class does Icon derive from?
What are the validation controls?
What''s the difference between an interface and abstract class?
How to read Unicode form PDF File and Save into DataBase ?
How to identify the color format of eps/tiff using c#?
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend