从 SYBASE SQLAnywhere 11.0 迁移到 SQL Server 2008 R2 Express
大家好，我有一个项目，要为我们的船员 Web 应用程序从 SQLAnywhere 11 迁移到任何新的关系数据库。迁移的原因是成本和支持问题。我需要选择一个免费的数据库，并具有 SQLAnywhere 的所有功能11.0。
以下是我想了解的有关 SQL Server 2008 R2 Express 的问题列表。
- 我们是否有任何迁移实用程序可以从 SQL Anywhere 11 迁移到 SQL Server 2008 R2 Express。
- 通过安装防护 MSI 部署 SQL Server 2008 R2 Express 是多么容易。
- 从 SQLAnyhere 11 迁移到 SQL Server 2008 R2 Express 的替代方法。
- 管理工具是否可以通过快速添加免费提供。我应该能够对数据库进行碎片整理和恢复。
谢谢
Hello everyone i have got a project to migrate from SQLAnywhere 11 to any new relational databases for our ship crew web application.The reasons for migrating is cost and support issues.I will need to choose a database which is free and has all features as SQLAnywhere 11.0.
Here is the list of Questions i want to know about SQL Server 2008 R2 express.
- Do we have any migration utility to move from SQL Anywhere 11 to SQL Server 2008 R2 express.
- How easy is deployment of SQL Server 2008 R2 express from install shield MSI.
- Alternative methods to migrate from SQLAnyhere 11 to SQL server 2008 R2 express.
- Do management tools come free with express addition. I should be able to defragment and restore the database.
Thank you
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
Sybase 有一个 SQL Server 迁移助手 (SSMA)（5.1 版刚刚在本周发布），但我对 SQL Anywhere 还不够熟悉，无法向您保证它是否有效，或者效果如何：
http://blogs.msdn.com/b/ssma/archive/2011/07/12/announcing-sql-server-migration-assistant-ssma-v-5-1.aspx
SQL Server Express 的部署相对容易，但我最近没有做任何将其合并到更复杂的安装程序中的工作。
如果您使用 Express w/Tools 或 Express w/Advanced Services，它们会附带 Management Studio Express。您还可以单独下载：
http://www.microsoft.com/ download/en/details.aspx?id=22985
请注意，Management Studio Express 缺少一些 SSMS 功能，例如管理代理，因此，如果您必须管理其他版本，您最好投资 49 美元（或较少的，取决于供应商）进入 开发者版，附带完整版 SSMS。
There is a SQL Server Migration Assistant (SSMA) for Sybase (v 5.1 was released just this week), but I am not familiar enough with SQL Anywhere to assure you whether, or how well, it works:
http://blogs.msdn.com/b/ssma/archive/2011/07/12/announcing-sql-server-migration-assistant-ssma-v-5-1.aspx
Deployment of SQL Server Express is relatively easy, but I haven't done any work recently incorporating this into a more complex installer.
If you use Express w/Tools or Express w/Advanced Services, they come with Management Studio Express. You can also download this separately:
http://www.microsoft.com/download/en/details.aspx?id=22985
Note that Management Studio Express is missing some of the SSMS functionality, such as managing agent, so if you have to manage other editions you may be better off investing $49 (or less, depending on vendor) into the developer edition, which comes with the full version of SSMS.