快速,持续,稳定,傻瓜式
支持Mysql,Sqlserver数据同步

数据库自动视图和查询转换。

请联系QQ:1793040 索取软件

使用ABCDBline软件可在不同数据库之间自动转换查询和视图。我们的解决方案在MS Access,MS SQL Server,MySQL,Oracle和PostgreSQL之间执行快速的视图和查询转换。

因此,现在您不必成为SQL专家,并且不需要您具备任何SQL知识就可以在各种数据库引擎之间转换视图/查询。

我们创新的解析器分析源数据库中的SQL语句,并相应地为目标数据库构建适当的类似物。

只需在定制阶段检查查询/视图是否需要在视图列表中进行翻译即可。其余的将自动为您完成。

使用我们的程序可以自动翻译以下视图类型:

  • SELECT类型查询/视图;
  • 具有标准功能的查询(不包括MS Access带有NZ前缀的统计信息)
  • 如果没有输入参数,则为MS Access使用SelectQuery和unionQuery。
  • MySQL和MS SQL的UNION,SUBQUERYS,CAST,CONVERT,EXIST语句的视图。

以下转换器在两个方向上提供视图转换支持:

  • MySQL和MSSQL
  • MSSQL和Oracle
  • MySQL和Oracle

视图查询转换仅在一个方向上可用:

  • 访问MySQL
  • 访问到MSSQL
  • Access到PostgreSQL

您可以在下面找到示例,这些示例显示了使用我们的软件翻译的视图/查询对。

MS SQL Server <=> MySQL

SELECT F_T_1.ID, A_1.Dsc,
(SELECT ELat FROM dbo.A AS A_2 WHERE (ELat = 'Row')) AS Expr1
FROM dbo.F_T AS F_T_1
RIGHT OUTER JOIN dbo.A AS A_1 ON F_T_1.ID = 
A_1.ID AND F_T_1.Tipo = A_1.Dsc
UNION
SELECT F_T_1.ID, A_1.Dsc, '#' FROM dbo.F_T
WHERE (F_T_1.Data > CONVERT (DATETIME, '2007-02-14 00:00:00'))
            
SELECT 'F_T_1'.'ID' AS 'ID', 'A_1'.'Dsc' AS Dsc,
(SELECT 'A_2'.'ELat' AS 'ELat' FROM 'a' 'A_2'
WHERE ('A_2'.ELat = 'Row')) AS Expr1
FROM 
('a' 'A_1' LEFT JOIN 'f_t' 'F_T_1' ON ((('F_T_1'.'ID' = 'A_1'.'ID')
AND ('F_T_1'.'Tipo' = 'A_1'.'Dsc'))))
UNION
SELECT 'F_T_1'.'ID' AS 'ID', 'A_1'.'Dsc' AS 'Dsc', '#' FROM 'f_t-1'
WHERE ('F_T_1'.'Data' > CAST ('2007-02-14 00:00:00' AS datetime))
            

MS SQL Server <=> Oracle

SELECT TOP (100) PERCENT dbo.dossiers.external_authorization,
dbo.dossiers.timestamp, dossiers_1.id
FROM dbo.dossiers 
INNER JOIN
dbo.GiornalePorto ON dbo.dossiers.id_nave = dbo.GiornalePorto.ID
INNER JOIN
dbo.dossiers AS dossiers_1 
ON dbo.GiornalePorto.ID = dossiers_1.id
WHERE (dbo.GiornalePorto.ID >= RAND(1))
ORDER BY dbo.GiornalePorto.DataOraConcordata
SELECT "dossiers" . "external_authorization",
"dossiers" . "timestamp", "dossiers_1" . "id"
FROM "dossiers" 
INNER JOIN 
"GiornalePorto" ON "dossiers" . "id_nave" = "GiornalePorto" . "ID"
INNER JOIN 
"dossiers" "dossiers_1" ON "GiornalePorto" . "ID" = "dossiers_1" . "id"
WHERE "GiornalePorto" . "ID" >= dbms_random.value(0, 1)
ORDER BY "GiornalePorto" . "DataOraConcordata"

MS Access <=> MS SQL Server

SELECT tblCategory.idCategory, tblPlants.ItemKey, "Product Name: " & tblCategory.name 
FROM tblPlants 
INNER JOIN tblCategory ON (tblPlants.PatentInfo = tblCategory.charCategoryName) AND (tblPlants.IDNumber = tblCategory.idCategory) 
WHERE ((("idCategory") < "IDNumber")) 
ORDER BY tblCategory.idCategory;
SELECT TOP 100 tblCategory.idCategory, tblPlants.ItemKey, "Product Name: " + tblCategory.name 
FROM tblPlants 
INNER JOIN tblCategory 
ON (tblPlants.PatentInfo = tblCategory.charCategoryName) AND (tblPlants.IDNumber = tblCategory.idCategory) 
WHERE ((("idCategory") < "IDNumber")) 
ORDER BY tblCategory.idCategory;

MS Access <=> MySQL

SELECT tblCategory.idCategory, tblPlants.ItemKey, "Product Name: " & tblCategory.name 
FROM tblPlants 
INNER JOIN tblCategory ON (tblPlants.PatentInfo = tblCategory.charCategoryName) AND (tblPlants.IDNumber = tblCategory.idCategory) 
WHERE ((("idCategory") < "IDNumber")) 
ORDER BY tblCategory.idCategory;
SELECT tblCategory.idCategory, tblPlants.ItemKey, CONCAT("Product Name: ", tblCategory.name) 
FROM tblPlants 
INNER JOIN tblCategory ON (tblPlants.PatentInfo = tblCategory.charCategoryName) AND (tblPlants.IDNumber = tblCategory.idCategory) 
WHERE ((("idCategory") < "IDNumber")) 
ORDER BY tblCategory.idCategory;

MS Access <=> PostgreSQL

SELECT tblCategory.idCategory, tblPlants.ItemKey, "Product Name: " & tblCategory.name 
FROM tblPlants 
INNER JOIN tblCategory ON (tblPlants.PatentInfo = tblCategory.charCategoryName) AND (tblPlants.IDNumber = tblCategory.idCategory) 
WHERE ((("idCategory") < "IDNumber")) 
ORDER BY tblCategory.idCategory;
SELECT tblCategory.idCategory, tblPlants.ItemKey, "Product Name: " || tblCategory.name 
FROM tblPlants 
INNER JOIN tblCategory ON (tblPlants.PatentInfo = tblCategory.charCategoryName) AND (tblPlants.IDNumber = tblCategory.idCategory) 
WHERE ((("idCategory") < "IDNumber")) 
ORDER BY tblCategory.idCategory;

相关推荐

咨询软件
 
QQ在线咨询
售前咨询热线
QQ1793040