distributing a SQL sever database? 2

[jgoodman00]

Is it readily possible to distribute a SQL server database, with an AccessXP project front-end? We have not yet moved the database into SQL server (it is currently still in access), but we currently distribute the data stored in our database on CDROM. Is this possible with a SQL server database, & how would you go about accomplishing this?? James Goodman
j.goodman00@btinternet.com

 

[foxdev]

You could use MSDE, which uses SQL Server data structures and commands - effectively, "SQL Server Lite" - with a limit of 2Gb database size. MSDE can be distributed to your customers. -----------------
Robert Bradley
use coupon code "TEKTIPS" for 15% off at:

http://www.lowcostprints.com

http://www.foxdev.com

 

[tlbroadbent]

You can detach your database from SQL Server using sp_detach_db with the @skipchecks option set to 'False'. Then copy the MDF file to the CDROM media. Reattach the database using sp_attach_db.

At the user site, the MDF file could be copied to the SQL data directory and attached using sp_attach_single_file_db.

These stored procedures are documented in SQL BOL. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[foxdev]

Terry, your answer brings up a murky point: you assume the destination has SQL Server, and I had assumed they did not.

I'm not sure which is correct, so James will have to help us out. -----------------
Robert Bradley
use coupon code "TEKTIPS" for 15% off at:

http://www.lowcostprints.com

http://www.foxdev.com

 

[jgoodman00]

Sorry about the ambiguity. The destination site will have MSDE, so my question was concerning the physical copying & initialising of the database itself. Are the stored procedures you referred to found packaged with MSDE, or just SQL server? James Goodman
j.goodman00@btinternet.com

 

[tlbroadbent]

They are included in MSDE also. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.