[Last Call] Learn how to a build a cloud-first strategyRegister Now


Can SQL database be re-created?

Posted on 2012-09-10
Medium Priority
Last Modified: 2012-09-24
I had a functioning ASP website that had an SQL database on the hosted server. I had a backup of the entire website. However, I do not have the accompanying SQL database. Is it possible for a knowledgable person to be able to recreate the SQL database from the information from website?
Question by:FrankU09
  • 2

Expert Comment

ID: 38385165
It is possible, but its a very long procedure................
LVL 16

Expert Comment

ID: 38385206
Well, you can create what is explicitly used by the ASP code, and what is inferred (for example, if there's SQL in the code that says "Select ID, FirstName, lastname from Employee" then you know that there's an Employee table with at least these 3 fields.

You can also infer what's in the database from data that's provided from other systems - for example, you might have a regular import from the payroll system that has some more fields, so you can work out some more of the fields in that table ...

However, you won't get any of the data, of course, and there'll be plenty of holes :(

OTOH, I would be very very surprised indeed if the hosting site did not have a backup of your database. It might take some effort to recover if they weren't backing it up as a database, but just as a file, but it could well be a far better bet. Remember; it's their rep on the line if they don't keep their clients' data safe, so anywhere they fail in that opens them up to a huge amount of bad publicity.
LVL 13

Accepted Solution

sameer2010 earned 750 total points
ID: 38385699
If you are using Entity Framework, then it would be easy to get it. Of course, without data, security, maintenance scripts, etc. But building the structure would be pretty easy.
LVL 16

Expert Comment

ID: 38386514
Does the Entity Framework retain the whole database structure, or just those parts actually touched by the program you're writing?

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Without even knowing it, most of us are using web applications on a daily basis.  In fact, Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We generally confuse these web applications to…
The viewer will learn the benefit of using external CSS files and the relationship between class and ID selectors. Create your external css file by saving it as style.css then set up your style tags: (CODE) Reference the nav tag and set your prop…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
Suggested Courses

829 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