TechTalkz.com Logo

Go Back   TechTalkz.com Technology & Computer Troubleshooting Forums > Tech Support Archives > Microsoft > Microsoft Expression

Reply
 
Thread Tools Display Modes
Old 07-06-2008, 09:54 PM   #1
Cowboy \(Gregory A. Beamer\)
Guest
 
Posts: n/a
TUTORIAL: Publishing your website database to a separate SQL Server

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.
http://tinyurl.com/5m63gg

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.
http://www.jimcobooks.com/Tutorials/default.aspx
(see the Membership link for the video)

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

Subscribe to my blog
http://gregorybeamer.spaces.live.com/lists/feed.rss

or just read it:
http://gregorybeamer.spaces.live.com/

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

  Reply With Quote
Old 12-06-2008, 10:06 PM   #2
Cowboy \(Gregory A. Beamer\)
Guest
 
Posts: n/a
Re: TUTORIAL: Publishing your website database to a separate SQL Server

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
http://gregorybeamer.spaces.live.com/lists/feed.rss

or just read it:
http://gregorybeamer.spaces.live.com/

********************************************
| Think outside the box! |
********************************************
"clintonG" <nobody@nowhere.com> wrote in message
news:eSaDXcJzIHA.1772@TK2MSFTNGP03.phx.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:E939B9FB-C7A0-49B9-ABFD-95C979DABB66@microsoft.com...
>>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.
>> http://tinyurl.com/5m63gg
>>
>> 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.
>> http://www.jimcobooks.com/Tutorials/default.aspx
>> (see the Membership link for the video)
>>
>> --
>> Gregory A. Beamer
>> MVP, MCP: +I, SE, SD, DBA
>>
>> Subscribe to my blog
>> http://gregorybeamer.spaces.live.com/lists/feed.rss
>>
>> or just read it:
>> http://gregorybeamer.spaces.live.com/
>>
>> *************************************************
>> | Think outside the box!
>> |
>> *************************************************

>


  Reply With Quote
Reply
Tags:


Thread Tools
Display Modes


Google
 


All times are GMT +5.5. The time now is 07:39 AM.


vBulletin, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
Copyright © 2005-2008, TechTalkz.com. All Rights Reserved - Privacy Policy
Valid XHTML 1.0 Transitional