Manu Varghese
Reputation: 811
Copy/clone SQL Server database schema and some data programmatically
I am developing a point-of-sale Windows Forms application which handling multiple companies. When user creating a new company, I want programmatically clone an existing database with some of the data (some master tables). I am using SQL Server Express and C#.
Upvotes: 0
Views: 787
Answers (1)
Mark Redman
Reputation: 24515
Instead of copying a database, could you not prepare a backup of an empty database with the data required, then restore that to a new database?
Upvotes: 1
Related Questions
- How to copy all schema from one database to other database (created at runtime)?
- Automatically / programmatically copy tables (structure and data) between SQL Server DBs
- Clone a SQL Server database programmatically
- How can I programatically clone a database schema in SQL Server?
- In VB.NET/C#, how do I copy a SQL table schema from on DB to another?
- How to create clone of database programatically
- Copy database schema to an existing database
- how can I copy the tables schema from database to another database using SqlserverCe in asp.net?
- How do I copy SQL Server 2008 database via C# code
- Copy SQL Server database in code