By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 2,140 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Dumped in my lap

P: n/a
Hopefully someone can help me, or at least direct me to the correct
newsgroup. I just inherited a project where a company created a fairly
complicated interactive website in ASP, provided it to a customer and didn't
give them the database to make it all work. The company went out of
business and I have a customer with everything to do the site but the
database. Is there any way to rebuild the database using the existing
pages? I am fairly proficient at databasing SQL and Access and good at
HTML, but can someone give me a good place to start in building up the
tables for this thing?

Paul Clemmons
PC Networks
Jul 19 '05 #1
Share this Question
Share on Google+
9 Replies


P: n/a
The pages would have no way of knowning anything about the database. You'll
have to go through to the code in the pages and see what comments are in
there and if the creator used dynamic SQL that will let you get the names
and relationships of DB objects and try to piece it together manually.

Ray at work

"Paul Clemmons" <pc*******@pcnetworkswa.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Hopefully someone can help me, or at least direct me to the correct
newsgroup. I just inherited a project where a company created a fairly
complicated interactive website in ASP, provided it to a customer and didn't give them the database to make it all work. The company went out of
business and I have a customer with everything to do the site but the
database. Is there any way to rebuild the database using the existing
pages? I am fairly proficient at databasing SQL and Access and good at
HTML, but can someone give me a good place to start in building up the
tables for this thing?

Paul Clemmons
PC Networks

Jul 19 '05 #2

P: n/a
"Paul Clemmons" <pc*******@pcnetworkswa.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Hopefully someone can help me, or at least direct me to the correct
newsgroup. I just inherited a project where a company created a fairly
complicated interactive website in ASP, provided it to a customer and didn't give them the database to make it all work. The company went out of
business and I have a customer with everything to do the site but the
database. Is there any way to rebuild the database using the existing
pages? I am fairly proficient at databasing SQL and Access and good at
HTML, but can someone give me a good place to start in building up the
tables for this thing?


You'll probably have to infer the database from the code. Look in code for
any object that is either assigned by .Execute([sql statement]) or by
Server.CreateObject("ADODB.Recordset"). In either the SQL statement that
creates the object, or the ("ColumnName") properties of the object, you
should see the column names that have to exist, and may get a sense even of
the datatype of the column from how it is used, or what it is named.

Good luck!
Jul 19 '05 #3

P: n/a
On Wed, 10 Dec 2003 06:16:52 -0800, "Paul Clemmons"
<pc*******@pcnetworkswa.com> wrote:
Hopefully someone can help me, or at least direct me to the correct
newsgroup. I just inherited a project where a company created a fairly
complicated interactive website in ASP, provided it to a customer and didn't
give them the database to make it all work. The company went out of
business and I have a customer with everything to do the site but the
database. Is there any way to rebuild the database using the existing
pages? I am fairly proficient at databasing SQL and Access and good at
HTML, but can someone give me a good place to start in building up the
tables for this thing?


Without documentation on the database structure, the best you can do
is start working through the coe, noting database, table and field
references. Hopefully the other company used field names like
FirstName or FName and not Field1. You may have to do a lot of work
with relationships, depending on how sophisticated the original
database was.

Jeff
Jul 19 '05 #4

P: n/a
Paul Clemmons wrote:
Hopefully someone can help me, or at least direct me to the correct
newsgroup. I just inherited a project where a company created a
fairly complicated interactive website in ASP, provided it to a
customer and didn't give them the database to make it all work. The
company went out of business and I have a customer with everything to
do the site but the database. Is there any way to rebuild the
database using the existing pages? I am fairly proficient at
databasing SQL and Access and good at HTML, but can someone give me a
good place to start in building up the tables for this thing?

Paul Clemmons
PC Networks


Did the customer provide specs for the application?

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Jul 19 '05 #5

P: n/a
Wow, thanks guys. I have been posting to groups here for years and this has
to be the fastest I have seen responses. I will let you know how it goes.
Paul
"Jeff Cochran" <jc*************@naplesgov.com> wrote in message
news:3f*************@msnews.microsoft.com...
On Wed, 10 Dec 2003 06:16:52 -0800, "Paul Clemmons"
<pc*******@pcnetworkswa.com> wrote:
Hopefully someone can help me, or at least direct me to the correct
newsgroup. I just inherited a project where a company created a fairly
complicated interactive website in ASP, provided it to a customer and didn'tgive them the database to make it all work. The company went out of
business and I have a customer with everything to do the site but the
database. Is there any way to rebuild the database using the existing
pages? I am fairly proficient at databasing SQL and Access and good at
HTML, but can someone give me a good place to start in building up the
tables for this thing?


Without documentation on the database structure, the best you can do
is start working through the coe, noting database, table and field
references. Hopefully the other company used field names like
FirstName or FName and not Field1. You may have to do a lot of work
with relationships, depending on how sophisticated the original
database was.

Jeff

Jul 19 '05 #6

P: n/a
If at all possible get hold of someone (anyone at all) from the other
'Company' and try to get hold of a sample / production database. Investigate
where the website was hosted and see if the host has the database. See if
the customer has any mobile numbers for contacts with the company - perhaps
they used contract developers?
If all this fails (and I'm pretty sure you will have tried all that) then
it's going to be a long, horrible, painful job to recreate the DB.
My suggestion is to get the customer spec on the site and create a new DB
(your own design), write and implement a DB access layer in your preferred
language of choice (script, VB, etc.) and then go through and re-connect the
pages to the new DB access layer.
Trying to re-create the original will be nigh on impossible unless its a
simple one or two table database.

Chris.

"Paul Clemmons" <pc*******@pcnetworkswa.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Hopefully someone can help me, or at least direct me to the correct
newsgroup. I just inherited a project where a company created a fairly
complicated interactive website in ASP, provided it to a customer and didn't
give them the database to make it all work. The company went out of
business and I have a customer with everything to do the site but the
database. Is there any way to rebuild the database using the existing
pages? I am fairly proficient at databasing SQL and Access and good at
HTML, but can someone give me a good place to start in building up the
tables for this thing?

Paul Clemmons
PC Networks

Jul 19 '05 #7

P: n/a
He provided me all the asp pages and images. It is like both ends of a
puzzle, with the middle ripped out. The company that created it for my
customer went out of business last year and the database went with it. My
customer has been trying to contact the owner, but 1) he is up in Canada and
sort of gone dark and 2) when he did contact him about two months ago, he
said that he could do it for another $5k (customer already paid $4600 for
what he has now) and it will be another month or so to do it. I am figuring
it will take me about two weeks to get the db back in place and put it on my
development server locally to test and find all the bugs in it.
Fortunately, the main thing the customer needs up is a news database and a
membership database up and running in short order, the rest is a bit later.
Phases.
"Bob Barrows" <re******@NOyahoo.SPAMcom> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...
Paul Clemmons wrote:
Hopefully someone can help me, or at least direct me to the correct
newsgroup. I just inherited a project where a company created a
fairly complicated interactive website in ASP, provided it to a
customer and didn't give them the database to make it all work. The
company went out of business and I have a customer with everything to
do the site but the database. Is there any way to rebuild the
database using the existing pages? I am fairly proficient at
databasing SQL and Access and good at HTML, but can someone give me a
good place to start in building up the tables for this thing?

Paul Clemmons
PC Networks


Did the customer provide specs for the application?

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Jul 19 '05 #8

P: n/a
Did the design firm also host the site. If not, the DB
may be available from their webhost or possibly on a
backup tape somewhere at the webhost.

Worth a try.

-----Original Message-----
Hopefully someone can help me, or at least direct me to the correctnewsgroup. I just inherited a project where a company created a fairlycomplicated interactive website in ASP, provided it to a customer and didn'tgive them the database to make it all work. The company went out ofbusiness and I have a customer with everything to do the site but thedatabase. Is there any way to rebuild the database using the existingpages? I am fairly proficient at databasing SQL and Access and good atHTML, but can someone give me a good place to start in building up thetables for this thing?

Paul Clemmons
PC Networks
.

Jul 19 '05 #9

P: n/a
Jon
In the ASP pages look for the part where it connects to the database (eg
strMDBpath = "e:\.........") this will tell you it's name and expected
location.

Next the fields and table name (strsql = "SELECT COLUMN_NAMES FROM tblNAME
WHERE .......)

The "COLUMN_NAMES" will be the fields, separated by commas.
The "tblNAME" will be the table name.

Look at the ASP page in Dreamweaver or whatever and see what sort of data
will go in the boxes etc, so if it expecting a data, set the field type to
date/time

And so on....

Certainly not worth $5k

Good luck

Jon

"Paul Clemmons" <pc*******@pcnetworkswa.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Hopefully someone can help me, or at least direct me to the correct
newsgroup. I just inherited a project where a company created a fairly
complicated interactive website in ASP, provided it to a customer and didn't
give them the database to make it all work. The company went out of
business and I have a customer with everything to do the site but the
database. Is there any way to rebuild the database using the existing
pages? I am fairly proficient at databasing SQL and Access and good at
HTML, but can someone give me a good place to start in building up the
tables for this thing?

Paul Clemmons
PC Networks

Jul 19 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.