Attaching and detaching databases are
standard operations used in SQL Server.
See
http://databasejournal.com/features/...le.php/2224361
1.
You should have a SQL Server Control Panel
of some sort provided by your ISP, so you can
work remotely on your SQL Server databases.
With it, you can execute system stored procedures,
like sp_detach_db and sp_attach_db, to detach and
attach databases.
2.
If you have SQL Server installed locally, too,
you can connect to the remote SQL Server
and execute sp_detach_db and sp_attach_db.
Juan T. Llibre
ASP.NET MVP
===========
"Skully" <Sk****@discussions.microsoft.com> wrote in message
news:AE**********************************@microsof t.com...
Thanks Scott,
Not sure I understand what you mean by "attach".
Once the scripts are generated, how do i execute them on the server if my
only view of it is through an ftp program?
"Scott Allen" wrote:
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/de...ary/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
>>>