Let’s say you want to export some data from your database SQL table to another database. If you have a decent number of items, for example less than 5000 entries, you can use the Script Wizard tool for that.
Follow the steps below to learn how to use Script Wizard:
Step 1) Right click on the database and select Generate Scripts…
Step 2) If you see the Introduction panel, click next, if not, go to next step.
Step 3) From the Choose Objects panel, click on Select specific database objects then select the database from which you want to export the data.
Step 4) From the Set Scripting Options panel, click Save scripts to a specific location then click Advanced and from General section, at Types of data to script select Data only and click Ok. After that you have to specify the path of the file where you want the script to be saved and click Next.
Step 5) After the Summary panel has appeared, click Next again and when the export is completed, click Finish.
That’s it! Now go and open the generated file and make use of the generated data.
Note: If you want to include in the generated file the SQL script for the creation of the table/s, please modify the Types of data to script to Schema and data at step 4).