i forgot the SQL 2005 tool that helps me extract the database into scripts

Question

Hello,

I forgot the name of that application tool. anyone here remembers it?

It let's me log-in to my remote SQL database and I can create scripts of the schema and procedures and even data.

Answer 1

I've found Sql Scripter to be the best tool for that job

Answer 2

Are you looking for SQL Server Database Publishing Wizard?

Answer 3

It's pretty simple to do this with SQL Server Management Studio 2005/2008.

To script database schema - right click the specific database in the Object Explorer, select Tasks->Generate Scripts and follow the wizard.

Answer 4

Hey mate,
Try DBSourceTools. http://dbsourcetools.codeplex.com
Its open source, and specifically designed to script an entire database - tables, views, procs and data to disk, and then re-create that database through a deployment target.