Thanks Ryan, that's good to know. Luckily we shouldn't have to move our databases to another server (we did it already 6 months ago when migrating to SQL Server 2005) and should we do it, then we would move all of them, not just one or two...
Thanks On 10 mar, 12:44, Ryan Rinaldi <[email protected]> wrote: > Just be careful since now you can't scale out to other database servers. > Moving one database requires that you move all of them that your application > references. > > -Ryan Rinaldi > blog:http://ryanrinaldi.com > > On Tue, Mar 10, 2009 at 6:49 AM, graphicsxp <[email protected]>wrote: > > > > > Sathish, > > > I've tried your solution an hour ago, and I still find it hard to > > believe that it actually worked ! I've been looking for an answer to > > this for a while and everybody was telling me that it is just not > > possible to do. But apparently it is, and it's actually very easy. > > > Thank you so much for your help ! > > > On 9 mar, 17:35, Sathish <[email protected]> wrote: > > > Are these databases reside in one server or in multiple servers? > > > > If it's one server following is the solutionhttp:// > > mikehadlow.blogspot.com/2008/10/mapping-entities-to-multiple-d... > > > > - > > > Sathish > > > > On Thu, Mar 5, 2009 at 12:48 PM, graphicsxp <[email protected] > > >wrote: > > > > > Hi, > > > > > I've got two business entities which are linked with a one to many > > > > association : > > > > > class Article > > > > { > > > > Publication p; > > > > } > > > > > class Publication > > > > { > > > > } > > > > > An article belongs to one publication only and a publication can > > > > contais 0 to n articles. > > > > > Now in my relational model this translates as : > > > > > [Article] {articleId, PublicationId} > > > > > [Publication {PublicationId} > > > > > This is pretty classic (I guess...), and it should be easy for > > > > nHibernate to persist the entities to my database. However, here is > > > > the catch : The two tables. [Article] and [Publication] are NOT in the > > > > same database, hence a different connection string, hence a diffrent > > > > NH mapping file.... > > > > > How can I workaround this ? Is there something that can be done ? > > > > > Thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
