我想将rdbms sqlserver更改为mysql或sqlserver更改为oracle [英] I want to change rdbms sqlserver to mysql or sqlserver to oracle

问题描述

我想使用不同的rdbms，如sqlserver，oracle，mysql等。现在，我使用mssql服务器作为主rdbms但是想使用其他rdbms如oracle和mysql.so，我的问题是..



1.我将把我的sqlserver数据复制到mysql和oracle吗？



2.是否有可能从asp.net c后面的代码更改rdbms连接字符串＃？



如果是，请解释它否则给我指示将整个mssql服务器数据复制到mysql和oracle并且还描述了连接字符串的变化。

I want to use different-different rdbms like sqlserver,oracle,mysql etc.Right now, i am using mssql server as a main rdbms but wants to use another rdbms like oracle and mysql.so, my question is..

1.how will i replicate my sqlserver data to mysql and oracle?

2.Is it possible to change rdbms connection string from code behind in asp.net c#?

If yes please explain it otherwise give me instruction of replication of whole mssql server data to mysql and oracle and also describe the change in connection string.

推荐答案

可能但很困难。

对于数据库复制，你可以使用SymentricDS一个开源工具声称将任何sql数据库转换为任何其他sql数据库。点击这里 -

http://www.symmetricds.org/ [ ^ ]



您可以更改连接字符串但是只是不足以使其发挥作用。您可能必须更改数据提供程序以及相应的逻辑和方法，以便与数据库进行通信并操作数据。



希望，这有助于：）

Possible but difficult.
For database replication you can use SymentricDS an open source tool which claims to convert any sql database to any other sql database. Check here-
http://www.symmetricds.org/[^]

You can change connection string but that only is not sufficient to make it work. You may have to change data provider and accordingly logic and methids for communicating with db and manipulating data.

Hope, that helps :)

这篇关于我想将rdbms sqlserver更改为mysql或sqlserver更改为oracle的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！