<div>
It's a 1 time deal only. &nbsp;How do I run the query exactly? They need all the data in the db. Can I do this or do I need to do it table by table?<br />
<br />
For example: server name is dbserver1, database name is photocollections1, and I want to save it to c:\dbdata.txt<br />
<br />
Thanks,<br />
<br />
Theo
</div>


It's a 1 time deal only.  How do I run the query exactly? They need all the data in the db. Can I do this or do I need to do it table by table?

For example: server name is dbserver1, database name is photocollections1, and I want to save it to c:\dbdata.txt

Thanks,

Theo

<div>
<div class="content wysiwyg-content">
Hi Everyone, I have a SQL Server 2005 db, and a client is asking for the data in a flat-file format.<br />
<br />
I gave them both a db backup and a scripted db file, but that's only the db structure.<br />
I also tried the Data Export wizard, exporting to a txt file, but still, no db data.<br />
<br />
Any idea how I can do this?<br />
<br />
Thanks,<br />
<br />
Theo
</div>
</div>


Hi Everyone, I have a SQL Server 2005 db, and a client is asking for the data in a flat-file format.

I gave them both a db backup and a scripted db file, but that's only the db structure.
I also tried the Data Export wizard, exporting to a txt file, but still, no db data.

Any idea how I can do this?

Thanks,

Theo

SQL Server - exporting db data in flat file

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.