How can I export my 2012 database with data to a .sql file so I can import it to a 2008 server? I've never been able to export the data only the structure.
SQL Server import and export wizard To begin, open the Import and export wizard, right-click a database and select the Tasks sub-menu -> Export data command: Connect to a source database via the Choose a data source step. Connect to a destination SQL Server database in the Choose a destination step.
You can right click on the database in management studio. then go to,
Tasks --> Generate scripts --> Advanced
There you can enable "Type of data to script" as Schema and data
, then generate the script. So that your script file will be populated with your data in table.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With