Use the right tool for each job. Flexible object-based access to a(ny)
SQL database? Use NHibernate! Efficient, secure, incremental backups?
use your database's tools!
Tangential: The sad truth is that in bigger organizations (that is,
where the money comes from), the people coding and the people running
databases are not the same and there is often no incentive for
convergence. Google "devops" for a totally different approach.
Best Regards, David
On 11.09.2012 09:30, EmptyNull wrote:
Might anyone know of an alternative perhaps then?
Or is using a custom function for every different database the only
viable option?
On Thursday, September 6, 2012 2:59:28 PM UTC+2, David Schmitt wrote:
NHibernate is not designed for this kind of work, the same way a baby
buggy is not built for hauling bricks: it's annoying for the first load
and it will break down long before the house is finished.
Even using stateless sessions, such a scheme will be horribly slow
compared to a true backup solution and will lack many important
features
like incrementals, compression and schema management.
Best Regards, David
On 06.09.2012 14:43, EmptyNull wrote:
> That is what I'm currently using.
>
> mysqldump.exe to get a dump of the database and mysql.exe to
restore the
> dump.
> But that only works on mysql databases.
>
> My boss wants that the code works for any databases hooked to
> nhibernate. Ie not only mysql but also mssql/etc
>
> On Thursday, September 6, 2012 2:38:11 PM UTC+2, Ramon Smits wrote:
>
>
> You are referring to a generic way to export/import a
complete data
> set I think. For example, doing an export of your app running
> against mysql and importing that data into an instance running
> agains mssql.
>
> Correct?
>
> --
> You received this message because you are subscribed to the Google
> Groups "nhusers" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/nhusers/-/tWDwmifgOLkJ
<https://groups.google.com/d/msg/nhusers/-/tWDwmifgOLkJ>.
> To post to this group, send email to [email protected]
<javascript:>.
> To unsubscribe from this group, send email to
> [email protected] <javascript:>.
> For more options, visit this group at
> http://groups.google.com/group/nhusers?hl=en
<http://groups.google.com/group/nhusers?hl=en>.
--
You received this message because you are subscribed to the Google
Groups "nhusers" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/nhusers/-/Zo6DVTaOWCUJ.
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.
--
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.
