SQL Table Names

May 22, 2013 at 5:52 PM
In the SqlTransactionRepository class, the table names are set to various values that reflect the data they contain. However, we are planning to include these tables and corresponding views in the same database that we use for other client information. Is there a way to add an optional, user-supplied prefix for these tables and views (something that could be included as an optional parameter, perhaps) so that these tables will be grouped together when we look at the database?

Thanks for all the work you've done on this project!!
May 22, 2013 at 6:06 PM
Yes, there is already a feature described here for specifying a schema and containerSchema so that you can separate these from the tables in your dbo schema. The schema will be generated for you if it doesn't already exist on your first attempt to load a file.

You could potential run this under multiple schemas if you didn't want different data sources to co-mingle.
May 29, 2013 at 11:37 PM
Thanks! That should work.

I did have a couple questions about the non-dbo schema. I ran it with a different schema, but SplitStatement and FlatElementsFunction are created with a dbo schema in CreateSplitStatementFunction and CreateFlatElementsFunction in DbCreation.cs. Also, the Revision table is created with the new schema, but the data is added to dbo.Revision in CreateRevisionTable in DbCreation.cs. Are those supposed to be prefaced with the schema?