Solved

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

Posted on 2004-08-04
10
1,919 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
10 Comments
 
LVL 9

Expert Comment

by:crescendo
Comment Utility
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 20 total points
Comment Utility
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 480 total points
Comment Utility
0
 
LVL 55

Author Comment

by:Jaime Olivares
Comment Utility
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:SurferJoe
Comment Utility
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
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 55

Author Comment

by:Jaime Olivares
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
I got it!!! (before crescendo's last post) I downloaded teratrax database and restored in the MSDE.
Thanks to all.
Jaime.

0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
MS SQL Bulk load data error 5 33
Move SQL 2005 Express to Server 2012R2 19 68
Microsoft SQL query 7 37
Numeric sequence in SQL 14 36
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now