Re: Deploying a SQL Server App
From: Scott Allen (scott_at_nospam.OdeToCode.com)
Date: 01/20/05
- Next message: Alvin Bruney [MVP]: "Re: Session Variables assigned to the wrong session?"
- Previous message: Scott Allen: "Re: How to read a DataSet?"
- In reply to: Skully: "Re: Deploying a SQL Server App"
- Next in thread: Skully: "Re: Deploying a SQL Server App"
- Reply: Skully: "Re: Deploying a SQL Server App"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 20 Jan 2005 08:31:24 -0800
Generally you don't want to deploy the database files per se (although SQL
2005 should make this easy). You could copy all the .mdf and .ldf files from
one server to another and use a script or enterprise manager to 'attach'
the database to the server.
The usual appraoch is to generate SQL scripts to recreate the tables and
any data needed then execute those scripts on the destination server. You
can generate scripts through SQL Server's enterprise manger.
Making sense?
-- Scott http://www.OdeToCode.com/blogs/scott/ > Thanks Scott, > One more question. To deploy the database which database files do I > put on > the server and where do I put them? > "Scott Allen" wrote: > >> Skully: >> >> Instread of using connection strings that are hard coded into your >> source code, try placing them into the web.config file and reading >> them at run time. When you deploy to a new server you'll just need to >> tweak web.config with the right connection string. >> >> there are ways to encrypt the string if you need the security boost. >> >> There is some discussion here: >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbco >> n/html/vbtskaccessingsqlserverwithexplicitcredentials.asp >> -- >> Scott >> http://www.OdeToCode.com/blogs/scott/ >>> If I have created my Web Application on my PC using command and >>> connection objects (dragging them onto the forms from the Server >>> Explorer window) how do I make it work when I deploy the application >>> (and presumably the dB) to the Host server? The connection objects >>> all refer to my PC not the server the app will eventually end up on? >>> >>> I guess my question is general. Where do I find out how to deploy a >>> SQL Server/ASP.NET app to a server.....? >>> >>> Thanks >>>
- Next message: Alvin Bruney [MVP]: "Re: Session Variables assigned to the wrong session?"
- Previous message: Scott Allen: "Re: How to read a DataSet?"
- In reply to: Skully: "Re: Deploying a SQL Server App"
- Next in thread: Skully: "Re: Deploying a SQL Server App"
- Reply: Skully: "Re: Deploying a SQL Server App"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
