I work with MySQL, and MySQL has a mysqldump client that scripts out database schemas + records in the tables.

There is no “native” tool in SQL Server 2000/2005 that does this (as far as I know). Luckily there’s a SQL Server add-in that allows scripting of both schema + records.

You can download the Database Publishing Wizard from CodePlex:
http://www.codeplex.com/sqlhost/wiki/view.aspx?title=database%20publishing%20wizard

VN:F [1.4.0_681]
Rating: 0.0/10 (0 votes cast)
Share :
  • Digg
  • del.icio.us
  • Google
  • description
  • StumbleUpon
  • Technorati
  • TwitThis

Related posts:

  1. Free Database Schemas ...
  2. Issue: Server principal is not able to access the database under the current security context ...
  3. Troubleshooting Database Mail ...
  4. How to Drop All Stored Procedures in Your Database ...
  5. Script to Drop/Recreate CHECK Constraints ...
  6. Follow up on Issue: Server principal is not able to access the database under the current security context ...