What are the challenges you face when working across database platforms? Take the survey

Exporting a table from a SQL database.

cchdpcyecchdpcye Posts: 3
edited December 8, 2009 11:50AM in SQL Compare Previous Versions
I am new in SQL comming from VFP running SQL server 2005 and would like to export a table to a txt file. Any idea for how could this be done?



  • Options
    Depending what you mean by 'export a table to a txt file', there are two ways of doing it in SQL Compare:

    1) If you have the Pro verison, save the database as a script folder (or just create an empty script folder and synchronize the table you want across)

    2) Otherwise, compare the database to itself and generate an XML report from the Tools menu (Generate Comparison Results Report).

    You can also export creation SQL for single objects in SSMS - just find the object in the object browser and choose the option from the context menu.

    Note that neither of these methods will export the data, only the structure.
    Software Developer
    Redgate Software
  • Options
    Thanks Michelle,
    I found a way to do so using the menu bar by right clicking while focusing on the database and select Tasks\Export Data the directions menus are explicit.
    Thanks for answering,
Sign In or Register to comment.