![]() I fired up Web Platform Installer and from the what's new tab I installed SQL Server Management Studio and browsed the db to make sure the data was there.Īt that point i tried the tool included with MSSQL "SQL Import and Export Wizard" but the result of the csv dump only included the column names. one will be the actual database and the other the log file.ĭisk='c:\temp\mydbName-v10.bak' WITH MOVE 'mydbName' TO Once you have this installed click on the database selection ( you are also required to download Frameworks and Runtimes)Īfter instalation go to the windows command prompt and: This requires the download of the Web Platform Installer "wpilauncher_n.exe" The method I used included part of Richard Harrison's method: together with this export tool and you will have an SQL script that contains the database. MOVE 'mydbName_log' TO 'c:\temp\mydbName_data.ldf' Īt this point you have extracted the database - then install Microsoft's "Sql Web Data Administrator". MOVE 'mydbName' TO 'c:\temp\mydbName_data.mdf', RESTORE DATABASE mydbName FROM disk='c:\temp\mydbName-v10.bak' This will list the contents of the backup - what you need is the first fields that tell you the logical names - one will be the actual database and the other the log file. restore filelistonly from disk='c:\temp\mydbName-v10.bak' There execute sqlcmd -S \SQLExpress (whilst logged in as administrator) So, install SQL Server Express edition, and open the SQL Server Powershell. SQL Server Express is free and will do the job. You will need to use SQL server to extract these. The bak file will probably contain the LDF and MDF files that SQL server uses to store the database. BAK files from SQL server are in Microsoft Tape Format (MTF) ref:
0 Comments
Leave a Reply. |