Hi

We are currently using the VS2008 GDR database projects to contain our database model and create database deployments scripts. We would like to move to the isolated database process of making changes, where each developer has a local copy of the Database (kept in sync with the GDR model)

Can LLBLGEN be configured to generate the .cs code files from a local (isolated) database? In the past we have tried but not found a way to do this.

Regards, MItch

Hi Mitch,

Could you please explain what did you try and didn't find the way?

LLBLGEN seems to tie itself to the object_id of a particular database. If the llblgen model is set up pointing to a database schema on a shared server, you don't seem to be able to copy the same schema to a loacl server and re-generate from that local schema. Does that make sense?

If you have the same database scehma with the same catalog name on a different server, then all you have to do is copy the lgp file, oen it and choose to refresh the catalog, and there you can point to the new SQL Server instance.