Solved

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

Posted on 2004-08-04
10
1,924 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 20 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 480 total points
ID: 11721146
0
Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

 
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

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

724 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