7 replies [Last post]
seb
Offline
Enthusiast
Last seen: 13 years 23 weeks ago
Joined: 2003-09-20
Posts: 208
Points: 0

One of our clients has turned around and decided that the product we've developed for him would be better on a CD instead of a website.

Currently have a MS SQL Server database. The obvious choice is to convert that to Access, but I reckon it'll be a few days work to go through all the SQL in the site and make it access-friendly.

Any other options? Need something that will run from the CD - 3rd party software is fine, so long as it's unobtrusive and doesn't need to install to the hard disk.

Tags:
Tony
Tony's picture
Offline
Moderator
Brisbane
Last seen: 4 days 5 hours ago
Brisbane
Timezone: GMT+10
Joined: 2003-03-12
Posts: 5343
Points: 2964

Running a database off of a CD

Hi seb,
Depending on how dynamic the data needs to be you may be able to download the whole site via one of the website downloaders and burn that to CD.

seb
Offline
Enthusiast
Last seen: 13 years 23 weeks ago
Joined: 2003-09-20
Posts: 208
Points: 0

Running a database off of a CD

That'd work for most of the site, but it has search pages which I can't see could be staticified Smile

roytheboy
roytheboy's picture
Offline
Guru
North Wales, UK
Last seen: 6 years 49 weeks ago
North Wales, UK
Timezone: GMT+1
Joined: 2004-09-18
Posts: 2233
Points: 41

Running a database off of a CD

I can't see how you can do this effectively Seb. You're going to have to run a web server and database from the CD without touching anything on the local system. Even if you do come up with some obscure bit of software that does the job, the chances of it working on Macs as well as Windoze would be slim at best. I'm no expert in this area but personally I would be doing my best to steer the client back in the direction of a web-based product. At a time when people are just waking up to the idea of web-based business systems, it seems a totally backward step to want to port the whole thing to CD :?

Life's a b*tch and then you die!

seb
Offline
Enthusiast
Last seen: 13 years 23 weeks ago
Joined: 2003-09-20
Posts: 208
Points: 0

Running a database off of a CD

There are actually some good reasons for selling it as a CD instead of a site in this case, but I can't go into them. One would be the cost though, this isn't cheap and the theory is it's tough to get someone to part with so much just for a username and password, at least with a CD you "get" something.

That said I can't deny I think they'd be better off just sticking to the site and marketing it better.

We've come up with another solution though... sell a laptop with IIS and MSDE preinstalled with the site on it...

roytheboy
roytheboy's picture
Offline
Guru
North Wales, UK
Last seen: 6 years 49 weeks ago
North Wales, UK
Timezone: GMT+1
Joined: 2004-09-18
Posts: 2233
Points: 41

Running a database off of a CD

seb wrote:
We've come up with another solution though... sell a laptop with IIS and MSDE preinstalled with the site on it...

Not knowing the product I can't tell if you're being serious or not, but if you are then you'll be handing over your source-code to every customer. In fact, this is also true if you manage to run it from a CD. If you use php then there is a tool that will effectively compile your scripts, making them quick to run and almost impossible to reverse-engineer, but I don't know if you can do this with whatever you're working in.

Life's a b*tch and then you die!

seb
Offline
Enthusiast
Last seen: 13 years 23 weeks ago
Joined: 2003-09-20
Posts: 208
Points: 0

Running a database off of a CD

Their are tools to do that with ASP too, but it is a very real concern, obviously anything that can be encrypted can be de-encrypted if someone's keen enough.

speedbird
Offline
newbie
UK Northwest
Last seen: 9 years 10 weeks ago
UK Northwest
Timezone: GMT+1
Joined: 2004-08-02
Posts: 4
Points: 0

Running a database off of a CD

I came across this in the MS site, which may be of use to you - either to do it, or to help persuade the client back to the web version :roll:

http://support.microsoft.com/kb/304007

Cheers
Carol