CODEWITHSUNDEEP
sqlsql-serversql-server-2005
Mr. Black
Mr. Black

Reputation: 12092

Convert .bak file into sql

I was export the database from SQL Server 2005, which is the format ".bak". I need to convert the .bak file into .sql file format. i.e convert .bak file into SQL statements.

Because, i have a many bak files ( which are exported from various SQL Server versions). So, i need to convert the bak into sql.

Thanks in advance.

Upvotes: 3

Views: 8125

Answers (2)

Dinesh vishe
Dinesh vishe

Reputation: 3598

restore database from .bak file. refer following link where generate script into sql file Get .sql file from SQL Server 2012 database

Upvotes: 0

My Other Me
My Other Me

Reputation: 5117

Restore the backup and then script it out to SQL statement with something like SQL publishing wizard.

Upvotes: 3

Related Questions