exporting data in sql server 2012

Question

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?

G. Stoynev · Accepted Answer · 2013-04-23 19:47:39Z

1

Right-click at the database node in SSMS Object Explorer (you're probably right-clicking a table node which wouldn't have "Export") (I assume you're talking about SQL Server Management Studio)

Here's a screenshot (Microsoft SQL Server Management Studio 10.0.2531.0):

enter image description here

edited Apr 23, 2013 at 19:47

answered Apr 22, 2013 at 4:08

G. Stoynev

7,8317 gold badges40 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jazzi Over a year ago

I am talking about SQL Server. But I still do not see Export

G. Stoynev Over a year ago

what version of SQL Server Management Studio?

karthi · Accepted Answer · 2013-04-22 05:30:15Z

0

Rightclick on database->click attack-> selct your database...

Make sure that data base backup should be make from that system... then only it will work.. if you copy from other sysytem means it wont work..

answered Apr 22, 2013 at 5:30

karthi

1,1093 gold badges10 silver badges23 bronze badges

Collectives™ on Stack Overflow

exporting data in sql server 2012

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related