Re: Advice needed: Best way to deploy/manage SQL db website

Thanks. I will look at the DB Publishing Wizard. I just create mostly
small websites with few tables and I just wanted to know the best "standard"
way to design and deploy a db-enabled website (with the ability to easily
make future db changes).

"Peter Bromberg [C# MVP]" <pbromberg@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:42FBA3D1-A14C-4039-97FD-B345AF5EED77@xxxxxxxxxxxxxxxx
There is NO DIFFERENCE between a SQLEXPRESS database and a SQL Server 2005
database. The only issue you may run into is the fact that SQLEXPRESS can
use
the "User Instance" connection string which web hosting companies do not
support, as it is only supported for localhost operation. Download the
Sql
Server "Database Publishing Wizard" (free from Microsoft) to create a SQL
script that allows you to migrate your local database to your hoster. Take
the time to "RTFM".
-- Peter
Site: http://www.eggheadcafe.com
UnBlog: htp://petesbloggerama.blogspot.com
Short Urls & more: http://ittyurl.net


"Bobby Edward" wrote:

Here's the situation....

1. Local dev environment is VS2005 and VS2008 / using SQL Express
databases
for data
2. Hosting company ONLY supports MS SQL Server 2005 databases

Here are the questions...

1. Should I develop using SQL Express, or would my life be easier if I
had
my local dev machine connected to a local SQL Server db? Any advantages
or
disadvantages?
2. After I'm done developing the website I want to deploy it in such a
way
that if I have to change the database schema (add fields, tables, etc...)
in
the future it's easy to do. Any recommendations?

I guess I'm not quite sure as to what is the "proper" way to make db
changes
to a db already in production (changes to schema, fields, tables,
etc...)?
I'm kind of lost.

What is the best way to do this?





.

Relevant Pages

  • Re: too many files....
    ... It's not until the website started ... most likely it is SQL dragging the whole thing down. ... The database queries themselves would be a good thing to ... query that retrieved all 4000 bugs in the databaseand he was ... ...
    (comp.os.linux.misc)
  • Re: Courtyard arrangement - Jeff Middleton
    ... I'm looking to set up a webserver for a public website and after ... allows us to put our products online but the database and ecommerce must ... Since you indicate SQL and WEB, you will make a rule that permits SQL ... SBS2003 SQL does not permit use of a web application without a license ...
    (microsoft.public.windows.server.sbs)
  • Re: Courtyard arrangement - Jeff Middleton
    ... I'm looking to set up a webserver for a public website and after ... our business accounting applicationthat is run on SBS ... We could have an ISP host the database application AND website or we ... Since you indicate SQL and WEB, you will make a rule that permits SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: Flat files and ASP.NET
    ... If it isn't extremely heavy I can't understand why SQL would ... visitors that came to my website. ... storing the data in a SQL Server database. ... So I am planning to use flat files instead of SQL Server ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Copy SQL SERVER 2008 database to sql Express 2008
    ... SQL 2008 uses the 2005 file format, so there is not much problem between 2008 and 2005. ... For older versions of the database, you have to set compatibility and will likely have to use the backup and restore method. ... That is what the Database Publishing Wizard does, ...
    (microsoft.public.dotnet.framework.aspnet)
Quantcast