Can SQL database be re-created?

Posted on 2012-09-10
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
    LVL 6

    Expert Comment

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

    Expert Comment

    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

    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

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

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Preface This article introduces an authentication and authorization system for a website.  It is understood by the author and the project contributors that there is no such thing as a "one size fits all" system.  That being said, there is a certa…
    This article covers the basics of the Sass, which is a CSS extension language. You will learn about variables, mixins, and nesting.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
    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 …

    734 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

    19 Experts available now in Live!

    Get 1:1 Help Now