Q

Utility to dump SQL Server Express database as text file

I want to dump my SQL Server Express database as a SQL Server text file including "create table and index statements, and "insert into ... statements for all tables." Postgres has such a utility called pg_dump. Any ideas?

I want to dump my SQL Server Express database as a SQL Server text file including "create table and index statements, and "insert into ... statements for all tables." Postgres has such a utility called pg_dump. Any ideas?
The new Visual Studio Team Edition for Database Professionals has this option. Alternately, you might just want to use some community resources like this one from CodeProject.
This was first published in February 2007

Dig deeper on Microsoft SQL Server Performance Monitoring and Tuning

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close