How to Access and Download Supermarket’s Database Correctly?

Asked By bmcaro 10 points N/A Posted on - 11/20/2012

I am having problem with supermarket data download. I need to get all the data from their database and I don't know where to start. What are the proper step by step when accessing database? I'm afraid if all the data will be deleted just because of me.

• Status: Open
• Question Views: 1713
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Databases

Answered By Toni Linscomb 5 points N/A #130366

How to Access and Download Supermarket’s Database Correctly?

 

You should mention the database management software for a specific solution (Ex. SQL Server, MySQL, and Oracle)

Since you haven’t mention the database technology I’ll give you the method to backup data in Sql Server database.

Login to the database server.

Open the Sql Server Management Studio.

Right click on the database. Go to Tasks -> BackUp…

Specify the backup destination in appearing screen and click OK.

.bak file will be created at the destination.

Then you can try restoring the database to get all the data.

 

About Toni Linscomb

Questions
0

Answers
197

Best Answers
86

• Vote Up 0 Vote Down

• Posted on - 11/20/2012
• Question Category: Misc Databases