SQL Server 2005, export table into inserts query

Question

I'm not able to find in SQL Server 2005 the utility that phpmyadmin has for exporting tables.

I need a way to dump all info a table contains in a query with all the instert into in it.

How can I do that with SQL Server 2005?

Check this link, hope it will help http://stackoverflow.com/questions/5225923/sql-server-equivalent-of-mysql-dump-to-produce-insert-statements-for-all-data-in — vpv, Jun 07 '12 at 11:01
and also this http://stackoverflow.com/questions/85186/mysqldump-equivalent-for-sql-server — vpv, Jun 07 '12 at 11:03

score 0 · Accepted Answer · answered Jun 07 '12 at 10:55

0

Use the Database publishing wizard tool you can find it under the SQL Server install directory

answered Jun 07 '12 at 10:55

anouar.bagari

1 Answers1