"Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
news:3k1vqdFs46v2U1@individual.net...
> hi Sanj,
> Sanjit Suchak wrote:
>> Hi,
>>
>> At the moment, using our VB6 / Access application, users can zip up
>> their .mdb files and send them to other users
>>
>> I have been reading that with SQL Server Express, you can treat
>> databases like Windows files allowing users to do this.
>>
>> I am wondering if it is possible to do something similar with MSDE?
>
> SQLExpress support somehow this feature just becouse a specific database
> option, the autoclose option, that specify to close the database when no
> longer in use... this feature is fully supported by ADO.Net part of the
> new framework becouse you can "open"/attach on the fly a database, but
> this, IMVHO, is a dangerous feature...
> as soon as a DBA turns that db option to false in order to achieve better
> performance you'll be deep in troubles...
> SQL Server database are not only a physical file on the file system, but a
> logical database too, that must be referenced and registered on the
> server...
> anyway.... MSDE supports a similar feature but requires you to manually
> detach the (user's) database from the server, moving it to the desired
> location and re-attaching it...
>
>> All the information I am have read indicates that it is not.
>> However, is it possible to write a simple tool in VB6 / .NET to do
>> this? Do any such tools exist, and have you any idea how large
>> such a file would be (beyond the size of the actual data in the
>> database I mean ... ) ?
>>
>> Unfortunately, we can not use SQL Server Express because it doesn't
>> support Win98 or WinXP Home.
>
> you can write your own, using the designed procedures,
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_da-di_83fm.asp
>
> as regard the file dimensions, you are "moving" a database that consists
> of (at least) 2 files, the data file and the transaction log file, and
> what you are moving is exactely as large as the original database is, and
> the minimal uncompressed size is of (about) 1mb for the data file and 1mb
> for the log file...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
>
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org > DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>
