YOu can do what is called detach on a database. Then send the client the db
and have a little exe that I wrote to copy the db to a directory and run
sp_attach_db. Look in books on line it has all the info needed.
Joshua Tipton
sp_detach_db (T-SQL)
Detaches a database from a server and, optionally, runs UPDATE STATISTICS on
all tables before detaching.
Syntax
sp_detach_db [@dbname =] 'dbname'
[, [@skipchecks =] 'skipchecks']
Arguments
[@dbname =] 'dbname'
Is the name of the database to be detached. dbname is sysname, with a
default value of NULL.
[@skipchecks =] 'skipchecks'
skipchecks is nvarchar(10), with a default value of NULL. If true, UPDATE
STATISTICS is skipped. If false, UPDATE STATISTICS is run. This option is
useful for databases that are to be moved to read-only media.
Return Code Values
0 (success) or 1 (failure)
Result Sets
None
Remarks
The detached files remain and can be reattached using sp_attach_db or
sp_attach_single_file_db. The files can also be moved to another server and
attached.
Permissions
Only members of the sysadmin fixed server role can execute sp_detach_db.
Examples
This example detaches the pubs database with skipchecks set to true.
EXEC sp_detach_db 'pubs', 'true'
-----Original Message-----
From: Joe Eugene [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 1:13 PM
To: CF-Talk
Subject: Re: SOT: Delivering MSSQL DB to Client
Jamie,
You can create a BACKUP of the database and send the client..just one
file.. they can use the file.. to create the new Database they need
import/export..whatever.
Joe
>From: "Jamie Jackson" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: SOT: Delivering MSSQL DB to Client
>Date: Tue, 10 Sep 2002 12:27:30 -0400
>
>What's the usual way to deliver a MSSQL (7) DB to the client? (IOW, How do
>you get it portable, so they can replicate the DB and data on their
>server?)
>
>Thanks,
>Jamie
>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
