将数据从 Advantage Database Server 传输到 SQL Server
我的客户正在使用 Advantage Database Server，并希望迁移到 SQL Server，但显然希望将所有客户端数据迁移到 SQL Server，作为升级的一部分。
我曾考虑过编写一个应用程序来进行传输，但认为它可能比它的价值更麻烦。
你会推荐什么？
My client is using Advantage Database Server and wants to move to SQL Server but obviously wants to move all his clients data as part of the upgrade over to SQL Server.
I've thought about writing an app to do the transfer but thinking it might be more trouble than its worth.
What would you recommend?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
我在开发应用程序时在sql server和advantage server之间切换，我主要使用sql server management studio中的导入数据功能来执行此操作。基本上，使用 oledb 驱动程序创建数据库并导入数据以获取优势 - 可从优势数据库网站获取。请尝试此链接了解更多信息。再次回去有点诡计......但那是另一个故事了。
如果这只是一次性转移就可以解决问题，那么您将对转移有相当程度的控制。请注意，有关 PK 和数据关系的信息可能无法在传输后保留下来，因为至少对于 adt/adi 文件，数据库服务器不会保留表之间关系的记录。如果他们想保持优势数据库运行并在两个数据库中保留数据副本，我还没有尝试过这样做。在这种情况下，OMG 小马的建议可能会奏效。
I have switched between sql server and advantage server while developing applications and I have mainly used the import data function within the sql server management studio to do this. Basically create a database and import data using the oledb driver for advantage - available from the advantage database website. Try this link for more information . Going back again is a bit tricker.... but that is another story.
If it is just a one off transfer that should do the trick you will have a fair degree of control over transfer. Be warned that the information about PK and data relationships may not survive the transfer as at least with adt/adi files advantage database server does not keep a record of the relationships between tables. If they want to keep the advantage database running and keeping a copy of the data in both databases i have not tried to do. The suggestion from OMG Ponies may do the trick in that case.
尚未使用（或听说过）Advantage Database Server，但我会：
对于不太永久的解决方案，您可以使用 OPENROWSET 打开连接到优势数据库。它使用与链接服务器相同的 OLE 驱动程序，但连接仅在您使用时打开。
Haven't used (or heard of) Advantage Database Server, but I would:
For a less permanent solution, you can use OPENROWSET to open a connection to the Advantage db. It uses the same OLE driver as you would with Linked Servers, but the connection is only open while you use it.
如果您觉得需要对 ETL 过程有更多的控制，您也可以使用 SSIS，否则正如 OMG Ponies 所建议的那样。正如 Sybase 所宣传的“零管理，无需 DBA”——您和您的数据迟早会摆脱这种情况。有一个可用的 ODBC 驱动程序，所以看起来可行。
You may also use SSIS, should you feel that you need more control over the ETL process, otherwise as OMG Ponies suggested. As Sybase advertises "zero-administration, no need for DBA" -- sooner or later you and your data grow out of this. There is an ODBC driver available, so it looks doable.