Transferring SQL Express data

[hairy_hats]

Hi all, Is it possible to move SQL Express databases between users and computers? TIA.

I hope you realise that hamsters are very creative when it comes to revenge. - Elaine

[Henry Minute]

Yes. At least, between computers is fairly easy (either copy or move), never tried between users but I would assume that it would also be relatively easy. If you have SQL Server Management Studio, use the Search option from the Help Menu and search for move database. If not, Google for sqlserver move database. Either way you will get loads of hits, as always, some more useful than others. :)

Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

[hairy_hats]

Thanks Henry, I wasn't sure if the restrictions in the Express version meant that the databases were limited to one user or computer.

I hope you realise that hamsters are very creative when it comes to revenge. - Elaine

[Henry Minute]

Coincidentally I have just found this[^] article on Database Journal about attaching Databases. Just in case you aren't aware of the method.

Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”