How to i get all the data from database within CD?

In my company i have one requirement.i have a database in sql server and i
have one report generation application to connect that database an it will
generate reports.for this client machine must have sql server.now my client
need data and application in one cd .he want to see the reports using that
cd.without sql server how can we access that database.is it possible ?
hi,
MOHAMED NASEER wrote:
> In my company i have one requirement.i have a database in sql server
> and i have one report generation application to connect that database
> an it will generate reports.for this client machine must have sql
> server.now my client need data and application in one cd .he want to
> see the reports using that cd.without sql server how can we access
> that database.is it possible ?
you can put a SQL Server/MSDE database on a CD (the like, as later
explained), but SQL Server/MSDE must be present and installed on the target
pc in order to acces that database and related data..
storing a database on CD support can be performed using sp_create_removable
system stored procedure, but this will always produce a 3 files set database
at least...
1 file storing the actual database data (that can be stored on the CD
support)
1 file for the transaction log (that can be stored on the CD support)
1 file for system tables that must stored in a read/write hosting area...
usually the targed pc hard disk..
the database will be of course a readonly database but a part of it, the
data file storing the system tables, must of course be read/write in order
to allow security features like granting database access rights and
permissions..
that's to say, a database can not be totally self contained in a CD-ROM and
more, before using it, it must be attached on to the target database via
sp_attach_db system stored procedure and detached via sp_detach_db before
ejecting the CD (the database will be marked as suspect as unavailable if
the detach operation is skipped)
further info about the sp_create_removable stored procedure and related
synopsis can be found at
http://msdn.microsoft.com/library/de...es_03_92hx.asp
and
http://msdn.microsoft.com/library/de...ca-cz_2e79.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply