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
- Tweet
Related posts:
- Dynamically Generate Database Snapshot Creation Script …
- Free Database Schemas …
- Issue: Server principal is not able to access the database under the current security context …
- Script to Drop/Recreate CHECK Constraints …
- Troubleshooting Database Mail …
- How to Drop All Stored Procedures in Your Database …
Filed under:
Tools
