Exporting a table from a SQL database.

cchdpcye

Hi,
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?

Thanks,
Yehuda.

Michelle T

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.

cchdpcye

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,
Yehuda.