Hi,
I need a tool or a program that helps me to convert an MS SQL backup
database file with the ( .bak) extension into ( .sql) , I need that
urgently please.
Many Thanks in advance.
Alabdulelahalabdulelah@.gmail.com wrote:
> Hi,
> I need a tool or a program that helps me to convert an MS SQL backup
> database file with the ( .bak) extension into ( .sql) , I need that
> urgently please.
> Many Thanks in advance.
> Alabdulelah
You can restore a SQL Backup to SQL Server using the RESTORE DATABASE
command. Once you've done that you can script the database schema as a
SQL script using the Generate Script feature of SQL 2000 Enterprise
Manager or SQL 2005 Management Studio. (I assume SQL scripts are what
you mean when you say you want a .SQL file?)
Scripting the data itself may be harder depending on how much and how
complex it is. Two possible solutions:
http://vyaskn.tripod.com/code.htm#inserts
http://www.red-gate.com/products/SQ...mpare/index.htm
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
订阅:
博文评论 (Atom)
没有评论:
发表评论