如何将SQL Server 2005数据库表导出到.DBF [英] How to export SQL server 2005 database table to .DBF

问题描述

您好。我有SQL Server 2005.我有我的数据库和表。我试图将表导出到.DBF文件的Foxpro程序。如何将我的SQL 2005数据库导出或转换为Foxpro的.DBF文件？

Hello. I have SQL Server 2005. I have my database and tables. I am trying to export the tables to .DBF file for a Foxpro program. How can I export or convert my SQL 2005 Database to a .DBF file for Foxpro?

推荐答案

这是为所有数据生成Insert语句的快速运行在您的表中，不使用SQL Management Studio 2008中的脚本或加载项：

1.右键单击数据库并转到任务 - >生成脚本

2.选择要生成脚本的表（或对象）。

3.转到设置脚本选项并单击高级按钮。

4.在常规类别中，转到脚本数据类型

5.有3个选项：仅架构，仅数据，架构和数据。选择适当的选项，然后单击OK。



然后，您将直接从SSMS获取CREATE TABLE语句和所有INSERT语句。



如果这样可以解决您的问题并将其标记为解决方案..谢谢..

This is a quick run through to generate Insert statements for all of the data in your table, using no scripts or add-ins to SQL Management Studio 2008:
1.Right click on the database and go to Tasks -> Generate Scripts
2.Select the tables (or object) that you want to generate the script against.
3.Go to Set scripting options and click on the Advanced button.
4.In the General category, go to Type of data to script
5.There are 3 options: Schema Only, Data Only, and Schema and Data. Select the appropriate option and click on OK.

You will then get the CREATE TABLE statement and all of the INSERT statements for the data straight out of SSMS.

If this solves your issue kindly up vote and mark this as solution.. Thanks..

这篇关于如何将SQL Server 2005数据库表导出到.DBF的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！