My database is quite big (around 2000 tables and 5000 stored procs). It takes forever to refresh entire catalog, especially stored procedure part. I need some way to add/refresh individual items in my catalog. I know I can create another database with subset of objects to refresh. But this is hassle I would like to avoid. As I understand there is no way to do it via standard designer. Is it possible to write plug-in which selects objects from the database and add them to my catalog?

Do you use all those tables & procs in your application? (in another words)Do you need them all in your LLBLGen project?

Check out the CommandLine Refresher and code generation projects found in the SDK pack.

Some references: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=2257 http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=4002 http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=6232

Be aware that you can pick the procs you want to load from the catalog(s), by setting the option in the preferences. This could solve the problem that you're pulling 5000 procs into the project.

It's also advisable, if you're using all procs, to create one project for the entities, and one project for the procs, as they're not related anyway.

I am not using all 2000 tables and 5000 procs in my project, this database is serving multiple projects. For this particular project, I am using less then 100 tables and procs.

I used preferences settings which allowed to specifically select stored procs to generate. Worked great for me. Thanks!

Just an idea to make user interface more user friendly, you can move this option to "[i]Catalog Refresh. Connect to the database.[/i]" window. I might be useful for many users.

Walter wrote:

I am not using all 2000 tables and 5000 procs in my project, this database is serving multiple projects. For this particular project, I am using less then 100 tables and procs.

I used preferences settings which allowed to specifically select stored procs to generate. Worked great for me. Thanks!

Just an idea to make user interface more user friendly, you can move this option to "[i]Catalog Refresh. Connect to the database.[/i]" window. I might be useful for many users.

That's indeed a good idea, to have that option as well on that dialog, and the value initially set by the preference setting. I'll add that to the list of v2.1 things to add (as it's pretty minor)