have got a back up of a database on cd. How do i transfare it into MS access or any other DBMS on my labtop?

Question

Its actually a back up of a system with real data that runs on MS SQL server. Do I need to install MS SQL Server on my sytem to import it or can import it into MS access. thanks for earlier reponse guys!

Answer 1

Depends what you mean by a "backup."

If what you have is a series of SQL statements, you can simply create a new database in Access, open the queries panel, create a new query in design view, switch to SQL view, paste the statements into the pane, then execute them.

If what you have is a differerent type of database, such as an ISAM file, you can try importing it in a new Access database via the import menu command.

Otherwise, describe better what you mean by "back up of a database."

Answer 2

That depends on what kind of backup it is.

First of all, if it's a windows backup created cd, or any other backup software for that matter, you'll have to restore the file onto your computer because most likely it's in a compressed format.

However, after that, you need to know what format it's in. If it's simply a MS Access file then you should be able to open it in MS Access. If it's an Oracle Export file, then you'll need to use Oracle's Import utility to import it into another Oracle database. If it's just a text file, then you should be able to import it into any database you want using their import tools. So, without knowing more details, it's kinda hard to give a good answer.

Answer 3

You need SQL Server. There is a free version at: http://msdn.microsoft.com/vstudio/express/sql/
Download this to your laptop. SQL Server comes with tools for viewing the entire database, but if it's a large or complex database you will need the programs which access it. Maybe these are also on the CD.

You also need to know how it was backed up in order to be able to restore it.

Answer 4

Look you can't disply mysql on Access cos threse diffreent btwen them.

But you can help you're self like that
Change the formate to .text And see what you write in the fil or Data base.

Answer 5

Hi. You need to stipulate what the original database and what the backup format is.

Answer 6

what sort of database file is it?

is it a text file? csv file?

if it is a text of csv file then you can import it into any database engine that you have access to! otherwise with out nowing what sort of backup file it is couldn't realy tell you anything else

Answer 7

http://www.techtutorials.net/

http://www.good-tutorials.com/
http://www.digitaljuice.com/
http://www.tutorialkit.com/
http://www.codestyles.com/
http://www.sitecube.com/website/promo_bw.asp?pid=sitetarget