It is obvious that I have to give the new DB info to NHibernate as the Schema and Catalogs, For much I have tried, I don't see it where and how...
Am Freitag, 12. Februar 2016 12:37:53 UTC+1 schrieb John Rolando Aristizabal Zuluaga: > > Hello everyone, > > For a year now I am being responsible for the DB infrastructure and the > Data Access Layer module in our project everything has been wonderful with > NHibernate and NEnvers. It is just now that I can't find the answer to my > new requirement... > > I asked the following in Stack Overflow but it seems that I won't have an > answer: > > > ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > > I want to have two separate databases with Nhibernate and NEnvers, one for > the production database (already fully functional) and the second which > contains the Audit info (Also fully functional but only with one database). > > I found and applied this here: NHibernate Envers - how to audit revisions > on a separate database? > <http://stackoverflow.com/questions/15071023/nhibernate-envers-how-to-audit-revisions-on-a-separate-database> > > It gives me the exception: > > > ADOExceptionReporter 10 SQL logic error or missing database > no such table: AuditDatabase.sqlite_master10:58:09,488 ERROR SchemaUpdate 10 > could not complete schema updateNHibernate.Exceptions.GenericADOException: > could not get table metadata: z_audit_ProductionMachine_AUD[SQL: SQL not > available] ---> System.Data.SQLite.SQLiteException: SQL logic error or > missing database > no such table: AuditDatabase.sqlite_master.......... > > > The audit implementation works without a problem with just one database, > but my requirement is to work with two. > > Any idea would be highly appreciated. > > > > ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > > > Does maybe anyone could give me a direction or an idea where should I look > or what I could try? > > > Thanks, > > John > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to nhusers+unsubscr...@googlegroups.com. To post to this group, send email to nhusers@googlegroups.com. Visit this group at https://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/d/optout.