?
Solved

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

Posted on 2004-08-04
10
Medium Priority
?
1,927 Views
Last Modified: 2008-02-01
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
Comment
Question by:Jaime Olivares
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
10 Comments
 
LVL 9

Expert Comment

by:crescendo
ID: 11721139
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
 
LVL 7

Assisted Solution

by:FDzjuba
FDzjuba earned 80 total points
ID: 11721140
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
 
LVL 9

Accepted Solution

by:
crescendo earned 1920 total points
ID: 11721146
0
Industry Leaders: 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!

 
LVL 55

Author Comment

by:Jaime Olivares
ID: 11721174
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
 
LVL 4

Expert Comment

by:Greg Rowland
ID: 11721640
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
 
LVL 55

Author Comment

by:Jaime Olivares
ID: 11721776
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
 
LVL 9

Expert Comment

by:crescendo
ID: 11721799
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
 
LVL 55

Author Comment

by:Jaime Olivares
ID: 11721822
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
 
LVL 9

Expert Comment

by:crescendo
ID: 11721860
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
 
LVL 55

Author Comment

by:Jaime Olivares
ID: 11721904
I got it!!! (before crescendo's last post) I downloaded teratrax database and restored in the MSDE.
Thanks to all.
Jaime.

0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question