Monday, March 19, 2012

Help! I need to make a database driven site

I have built databases in Access before (i'm not bad at that) and i
can build websites (not great but OK) but i have never combined the
two thus far. However i now need to make a database driven website for
my client who has a quite large website with many visitors.
I know that they would not be happy about buying MS Sequel, however
the remote web host for their site has a MS sequel licence.
All i want to do be able to do is to design and build the database and
pages myself before it all gets uploaded to the net then i imagine i
would connect all of this up somehow (another story)
Will i need to get a MS sequel licence for my computer, if all i want
to do is design and build a database which will be hosted on a web
host that has the sequel licence, or could i use MSDE or MS Sequel
developers edition to build a database on my computer and then upload
to the web server?
Just to clarify i will be doing this all on my single computer which
isn't network and is just for little old me to design and upload
websites on.
If this is the case, could i use the familiar MS access as my front
end with MSDE or MS Sequel developers edition as the back end?For development and testing purposes you can purchase SQL Server Developer
Edition for $50. Unlike MSDE this includes the client tools such as Query
Analyzer and Enterprise Manager.
http://www.microsoft.com/sql/howtobuy/development.asp
--
David Portas
SQL Server MVP
--|||or look into the new "Sql Server 2005 Express" it is the "NEW" MSDE.
http://lab.msdn.microsoft.com/express/sql/
Cheers,
Greg Jackson
PDX, Oregon|||> If this is the case, could i use the familiar MS access as my front
> end with MSDE or MS Sequel developers edition as the back end?
For web development I'm not sure why you'd need it but yes, you can use
Access as a front-end to SQL Server.
--
David Portas
SQL Server MVP
--

No comments:

Post a Comment