• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1932
  • Last Modified:

URGENT: Want to extract data from a MS-SQL backup file

Hi all,
I have received a Microsoft SQL Database file (without extension). I want to retrieve information from this file but I don't have a Microsoft SQL Server, just a MySQL database where I want to migrate data to.
It doesn't matter if I can't migrate directly, just want to retrieve data from backup file in any format, let say, in CSV, is there any free or shareware tool to do this?
Thanks in advance,
Jaime.
0
Jaime Olivares
Asked:
Jaime Olivares
2 Solutions
 
crescendoCommented:
No, but you can download the "free" MSDE, the "desktop edition" of SQL Server, which is fully functional for what you want and will run on any modern PC.
0
 
FDzjubaCommented:
what is this file you have received? backup or just straight forward copy of database

if this is database then i doubt you can do it manually without sql server or special tools, (not that i know of any that will allow this)

how big is your database backup file, i got MS SQL and can install mysql to play around with
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Jaime OlivaresSoftware ArchitectAuthor Commented:
crescendo:
Thanks, I will try it, can you provide me the link?

FDzjuba:
It is a file with no extension, I have read with an hex editor and says "TAPE" ......."Microsoft SQL Server" .... and continues legible fields, and data.
>how big is your database backup file, i got MS SQL and can install mysql to play around with
It is just 11 Mb, I preciate your offer, I will try MSDE first if possible.
0
 
Greg RowlandSoftware Designer, SysDBA, WebMaster OwnerCommented:
Gee,
  Try to find a trial Versoin CD of SQL  server some where, like,

http://www.microsoft.com/sql/evaluation/trial/default.asp?SD=GN&LN=EN-US&gssnb=1

HTH,

G
0
 
Jaime OlivaresSoftware ArchitectAuthor Commented:
Ok, I have downloaded MSDE and now is running.
I have downloaded MSDE Plus as a tool.
Now I want to restore from file but I have not a pre-existent database. Is that possible?
I can't find an option to do that.
Or maybe need another MSDE utility.
0
 
crescendoCommented:
You just need to create a database first, use the same name as the original, and put the files in the same place if possible.
0
 
Jaime OlivaresSoftware ArchitectAuthor Commented:
I have created database with the same name using MSDE
I don't see a restore function in MSDE Plus, this can be made with an SQL sentence? If yes, please give me an example.
BTW. I don't know table filenames, I can see some with the hex editor, but maybe miss some.
0
 
crescendoCommented:
Example from Books Online:

RESTORE DATABASE MyNwind
   FROM C:\YourBackupFileName
   WITH NORECOVERY,
      MOVE 'MyNwind' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\NewNwind.mdf',
      MOVE 'MyNwindLog1' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\NewNwind.ldf'
RESTORE LOG MyNwind
   FROM C:\YourBackupFileName
   WITH RECOVERY

But you have to know the logical name of the data (MyNWind) and log (MyNWindLog1) files. You can get this by executing:

RESTORE FILELISTONLY
FROM C:\YourBackupFileName


0
 
Jaime OlivaresSoftware ArchitectAuthor Commented:
I got it!!! (before crescendo's last post) I downloaded teratrax database and restored in the MSDE.
Thanks to all.
Jaime.

0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now