1

I would like to export certain tables of the database to a .sql flat file using SQL Server 2012.

I went to SQL SERVER Management Studio -> Right Clicked on the database I would like to export -> Task -> Export Data

Then I landed on this page

enter image description here

Then I created a filename, Entered " for a Text qualifier

Then I clicked the next button and landed on this screen.

enter image description here

I am unable to continue from here due to the following error:

Columns are not defined for this connection manager.

Improve this question
5
  • You don't want to use 'Flat File Source' as your data source, you want to use SQL Server as your source. Change this and try again. Commented Apr 1, 2015 at 6:50
  • See if this is easier: stackoverflow.com/questions/11884965/… Commented Apr 1, 2015 at 6:51
  • @Nick.McDermaid its definitely much easier. Commented Apr 1, 2015 at 7:04
  • @Nick.McDermaid I would like to include the data as well Commented Apr 1, 2015 at 7:09
  • 1
    When you "Change “Script Data” option to true" as per the link it should export the data as INSERT statements Commented Apr 1, 2015 at 7:28
Related questions
21
SQL Server: how do I export entire database?
29
How to backup Sql Server to sql file?
0
Export - Text File - SQL Database
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.