Freitag, 6. April 2012 08:08
Hi all. I hope you can help me out here.
If I want to pre-provision a database with say 2 tables with data that I want to hand out to 10 engineers what is the best way.
Currently I am provisioning the tables before deployment and then creating a snapshot. They then use the copied .sdf. It means I effectively have two copies of the database in bin/debug.
I am thinking why can't I provision the one database run the application locally, create and provision the .sdf in bin/debug then once stopped just copied the now provisioned sdf back to the root of my project and then that will get distributed to the clients.
Sorry really quickly thought out question as I'm off out. Many thanks Scott
Freitag, 6. April 2012 08:47got a funny feeling I'm being an idiot. Presumably I need to create the snapshot and then distribute that.
Freitag, 6. April 2012 11:44Moderatoreach scope that is provisioned has some kind of a unique id to differentiate it from other copies...if you distribute a provisioned database, that means each copy will have the same id... a snapshot is almost the same except that Sync Framework can detect it's a snapshot and automatically adjust the metadata accordingly.
- Als Antwort markiert scottsanpedro Freitag, 6. April 2012 11:58
Freitag, 6. April 2012 11:59Thanks JuneT. Had that sudden realisation I wasn't doing something right. Appreciate your time. Scott