Creating a SQL Script from a .bak file

Question

Hello,

How can I create a SQL Script (*.sql) file from a ".bak" file? This is for SQL Server 2005. Can I create a SQL Script with just the SQL Server 2005 Express?

Your question has already been answered. https://stackoverflow.com/questions/8496737/opening-a-sql-server-bak-file-not-restoring — Jonathan Ouwens, Mar 24 '14 at 16:53
Restore the database and then script it out just schema, or schema and data. — Tony Hopkinson, Mar 24 '14 at 16:53

score 0 · Accepted Answer · edited May 23 '17 at 12:15

0

Above comment from Tony Hopkinson was the solution.

edited May 23 '17 at 12:15

Community

1
1

answered Mar 30 '14 at 09:26

Codename K

890
4
23
52

How to script it out?Please explain.Thanks – SwR Aug 20 '16 at 05:38

Creating a SQL Script from a .bak file

1 Answers1