CODEWITHSUNDEEP
sqlsql-serverdatabase-backups
Mark
Mark

Reputation: 83

SQL Server : copy database data and structure including aspnet security to blank database

I have to transfer the data and structure of a SQL Server database to an already created empty database.

I have 4 tables with auto-increment keys, where 3 tables are sub tables of the master. The database also has the ASP.NET membership tables, which I need to copy across as has user data.

Any ideas, I have tried usually SQL Server 2012 Management Studio, but won't keep the auto inc keys and ASP.NET membership tables.

Upvotes: 0

Views: 263

Answers (1)

M.Ali
M.Ali

Reputation: 69554

You have two simple options

  1. backup and Restore database on the target server.

  2. But since you have mentioned you want to copy the data and schema from one database to another empty(existing) database, I would suggest SQL Server Scripting would be a better option for you. You can scripts sql-server objects and data (just data or just schema) and execute these scripts on the target database.

Upvotes: 1

Related Questions