
February 16th, 2005, 03:48 AM
|
|
Registered User
|
|
Join Date: Oct 2004
Posts: 20
Time spent in forums: 3 h 54 m 46 sec
Reputation Power: 0
|
|
|
using SQLserver db dynamically
I would like to create program that load SQLserver database file from a mobile disk (eg. flash disk),
the db should be flexible to move to any other computer and SHOULD NOT stay in the harddisk
i've been thinkin of solution:
1. i should do automatically attach of db to the sqlserver everytime i load the program
2. auto detach the db when finish using the program
3. and the file will be in .mdf instead of a backup file (since backup file need restoration and restoration
will restore file to the harddisk )
is my solution correct or is there any better solution?
|