TUTORIAL: Publishing your website database to a separate SQL Server

Cowboy \(Gregory A. Beamer\)

I just finished a blog on publishing your database to a website. I wrote the
tutorial to cover the many who are not able to use the App_Data folder
"attach" method.

My tutorial is when you are publishing to a host that has given you a SQL
Server database on a separate machine. This scenerio is common with many
ISPs, who may also give you options like MySql, SQL Server and Access. If
your ISP gives you a separate SQL logon, this is the tutorial for you.


This is a bit different from the approach Jim Cheshire has taken, which is
to use the App_Data and "attach" to a SQL Express instance on a web server
through the config file. Jim's option is valid, if your ISP has it set up
that way and I would recommend doing it that way if you have the option.

(see the Membership link for the video)

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog


or just read it:


*************************************************
| Think outside the box!
|
*************************************************

Cowboy \(Gregory A. Beamer\)

I will have to follow this up at some time.

One of the difficulties, especially for those without much development
experience, is working through deployment issues. It is easy enough to get
everything working locally, but then you have ot work with your ISP.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog


or just read it:


********************************************
| Think outside the box! |
********************************************
"clintonG" <> wrote in message
news:.gbl...
> Thanks Cowboy, you know what is --really really really-- needed is a guide
> and methodology of Best Practices to update a deployed database with new
> tables and data that are continually being developed or refined on the
> development machine.
>
>
> "Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@comcast.netNoSpamM> wrote in
> message news:...
>>I just finished a blog on publishing your database to a website. I wrote
>>the tutorial to cover the many who are not able to use the App_Data folder
>>"attach" method.
>>
>> My tutorial is when you are publishing to a host that has given you a SQL
>> Server database on a separate machine. This scenerio is common with many
>> ISPs, who may also give you options like MySql, SQL Server and Access. If
>> your ISP gives you a separate SQL logon, this is the tutorial for you.
>>
>>
>> This is a bit different from the approach Jim Cheshire has taken, which
>> is to use the App_Data and "attach" to a SQL Express instance on a web
>> server through the config file. Jim's option is valid, if your ISP has it
>> set up that way and I would recommend doing it that way if you have the
>> option.
>>
>> (see the Membership link for the video)
>>
>> --
>> Gregory A. Beamer
>> MVP, MCP: +I, SE, SD, DBA
>>
>> Subscribe to my blog
>>
>>
>> or just read it:
>>
>>
>> *************************************************
>> | Think outside the box!
>> |
>> *************************************************
>