blocks|key|1681951|text|你查过了吗|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1681952|http://db.apache.org/ddlutils/|offset|length|1681953|或|1681954|http://publib.boulder.ibm.com/infocenter/wtelecom/v6r1/index.jsp?topic=%252Fcom.ibm.twss.plan.doc%252Fdb_scripts.html|1681955|entityMap|0|LINK|mutability|MUTABLE|url|1|http://publib.boulder.ibm.com/infocenter/wtelecom/v6r1/index.jsp?topic=%252Fcom.ibm.twss.plan.doc%252Fdb_scripts.html^0|0|0|U|0|0|0|0|35|1|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@$D|U|E|V|1|W]]|A|$]]|$1|F|3|G|5|6|7|X|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|Y|8|@]|9|@$D|Z|E|10|1|11]]|A|$]]|$1|J|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|C]]|Q|$5|M|N|O|A|$P|R]]]]

Did you check

<a href="http://db.apache.org/ddlutils/" rel="nofollow">http://db.apache.org/ddlutils/</a>

or

<a href="http://publib.boulder.ibm.com/infocenter/wtelecom/v6r1/index.jsp?topic=%2Fcom.ibm.twss.plan.doc%2Fdb_scripts.html" rel="nofollow">http://publib.boulder.ibm.com/infocenter/wtelecom/v6r1/index.jsp?topic=%2Fcom.ibm.twss.plan.doc%2Fdb_scripts.html</a>

blocks|key|664382|text|既然您已经在使用ADO，那么您应该研究一下Microsoft+ADOX|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|664383|这使您可以使用独立于基础数据源类型的ADO对象模型来操作数据源中的结构。也就是说，不使用显式DDL|664384|任何给定的ADO提供程序都不保证对ADOX的支持，即使提供了ADOX支持，其级别也可能会有所不同。但是对于MS+Access和MS+SQL+Server，我认为您会找到所需的所有功能(甚至更多！)|664385|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/ms677200%2528v=vs.85%2529.aspx^0|L|E|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]]]

Since you are already using ADO, you should look into <a href="http://msdn.microsoft.com/en-us/library/ms677200%28v=vs.85%29.aspx" rel="nofollow">Microsoft ADOX</a>

This allows you to manipulate structures in a data source using an ADO object model that is independent of the underlying data source type. i.e. without resorting to explicit DDL

Support for ADOX is not guaranteed by any given ADO Provider, and the level of ADOX support may vary even when it is available. But for MS Access and MS SQL Server I think you will find all the capability you require (and quite possibly more!)

blocks|key|4333307|text|我也有同样的问题。我解决了这个问题，在执行SQL之前对它应用C预处理器。预处理器包括宏，以便处理不同的dbs。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4333308|斯特凡诺|4333309|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I had the same problem.
I resolved it applying a C preproccessor to the SQL before executing it.
The preprocessor includes macros in order to handle the different dbs.

Stefano

blocks|key|1681995|text|这可以在Delphi中使用DBX来完成。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1681996|下面是示例代码的链接，展示了如何做到这一点。http://cc.embarcadero.com/item/26210|offset|length|1681997|entityMap|0|LINK|mutability|MUTABLE|url|http://cc.embarcadero.com/item/26210^0|0|M|10|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

This can be done using DBX in Delphi.

The following is links to sample code showing how this can be done.
<a href="http://cc.embarcadero.com/item/26210" rel="nofollow">http://cc.embarcadero.com/item/26210</a>

I'm working on a desktop application that must support (currently) MS Access and SQL Server back ends. The application is under constant development and changes are frequently being made to the database, mostly the addition of tables and views to support new features (but also some DROPs and ALTER TABLEs to add new columns).

I have a system that compiles the DDL into the executable, checks the database to see if the executable has any new DDL that has to be executed, and executes it. This works fine for a single database.

My immediate problem is that SQL Server and Access support wildly different names for data types so a CREATE TABLE statement that executes against Access will not execute against SQL Server (or worse, will execute but create a table with different datatypes).

Is there a method that can be used to create DDL (especially CREATE TABLE commands) that can be executed through ADO against both of these databases without having to craft separate DDL for each provider?

Compatible DDL (CREATE TABLE) across different SQL databases?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在开发一个桌面应用程序，它必须支持(当前) MS Access和SQL Server后端。该应用程序正在不断开发中，并且经常对数据库进行更改，主要是添加表和视图以支持新特性(但也有一些删除和更改表以添加新列)。我有一个系统，它将DDL编译成可执行文件，检查数据库以查看可执行文件是否有任何必须执行的新DDL，然后执行...

问跨不同SQL数据库的兼容DDL (CREATE TABLE)？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问跨不同SQL数据库的兼容DDL (CREATE TABLE)？EN