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

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.

Closed 8 years ago.

Improve this question 开发者_开发问答

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.

---

Are you looking for SQL Server Database Publishing Wizard?

---

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.

---

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.