Hi,

Our situation is like this:

  • We have a legacy DB which is used by older applications that retrieve data using LINQ to SQL.
  • We are starting with new development in September with DO into new tables.
  • Both applications manipulate data from the other application.

The old DB has grown out of proportions and has become very hard to maintain. In the application we are going to separate functionality by using a facade between the old and new application using DTO's.

We would also need synchronized transactions (2 phase commit) across the two DB's which would complicate things too.

A problem with 2 DB's is the synchronization of backups and consistency of data across. Both Application manipulate data from the other applications DB so we need to have a mechanism that backups both DB with consistent data. A solution could be to backup both DB with Log (MSSQL) and at restore time rollback to a certain POINT IN TIME.

We make things a lot easier when all the data is in the same DB. The question here is. Is DO capable of maintaining only a part of the tables in a DB (leaving the old tables intact)?

Regards Paul

asked Aug 09 '12 at 05:04

Paul%20Sinnema's gravatar image

Paul Sinnema
261888896

edited Aug 09 '12 at 05:07


One Answer:

Hello Paul,

The minimal level of granularity DataObjects.Net can operate with is database schema. So I'd recommend to put new tables in the same database but in a different schema, like this:

<domain name="Default" upgradeMode="Recreate"
    connectionUrl="sqlserver://localhost/DO40-Tests"
    defaultSchema="NewSchema" />

Hope that helps.

answered Aug 09 '12 at 05:22

Dmitri%20Maximov's gravatar image

Dmitri Maximov
22111211

Your answer
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!
toggle preview

Subscription:

Once you sign in you will be able to subscribe for any updates here

Tags:

×3

Asked: Aug 09 '12 at 05:04

Seen: 2,267 times

Last updated: Aug 09 '12 at 05:22

powered by OSQA