title: exporting data in sql server 2012
body: <p>i am trying to export data from the database I created in SQL Server 2012 so that I may take it to school and copy it all over to the main server there. I was shown how to do it on campus in the computer lab but whenever I right click the table and go for Tasks>Export There is not an option for Tasks. I also couldn't just generate the script I had to Right click table, Script Table as>Create to>New Query. Any suggestions?</p>