Reputation: 360
i want to export data and schema from live Database to my local database, i tried "export data" option while right clicking on live db but it only exports data but not constraints on columns. kindly help me out?
Upvotes: 0
Views: 246
Reputation: 542
Try this:
If the database is big you will need to execute the script using the prompt in your local database.
Upvotes: 2