Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dumping MS SQL Database to text file

Status
Not open for further replies.

Guest_imported

New member
Joined
Jan 1, 1970
Messages
0
I search how can I dump a MS SQL Database in one or more text file. My version is MS SQL Server 7.0
Is-it possible ?
How ? With tools integrated in MS-SQL ?
If not, is there a product which can do that ?

As you can see, I'm not a SQL Specialist, so the solution must be done by a non expert person.

Thank you for your help,

Fabrice,
 
You can dump the data from tables in a SQL 7 database using DTS, BCP, OSQL, and many other methods. Read about DTS (Data Transformation Services) in SQL Books Online. Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top