从2005年到2013年升级sql数据库 [英] upgrade sql database from 2005 to 2013

问题描述

hii，

我已经使用sql database 2005在visual studio 2008中制作了我的项目。现在我想在拥有带有sql database 2013的visual studio 2008的pc中运行我的项目。这是可能的在那台电脑上运行我的项目。它会对我的项目产生任何影响。

尽快回复。

hii,
I have made my project in visual studio 2008 with sql database 2005.Now I want to run my project in pc which has visual studio 2008 with sql database 2013.Is is possible to run my project on that pc.Will it have any affect on my project.
reply as soon as possible.

推荐答案

我们从SQL 2005到SQL 2012最近，发现没有太多问题。假设您已将代码设置为正确地使用标准方法将信息传递到SQL Server，它应该可以正常工作。



我遇到的一个与触发器相关的问题，尤其是系统生成的（用于执行关系等）。那里使用的一些代码（系统生成的）已被弃用，不再有效。找到它们并更新它们很繁琐，但并不是特别困难。

We migrated from SQL 2005 to SQL 2012 recently, and found that there weren''t too many issues. Assuming you have set your code up to pass through information to your SQL Server correctly, using standard methods, it should work.

One issue I did come across related to Triggers, particularly system generated ones (for enforcing relationships etc). Some code that was used in there (system generated) had been deprecated, and no longer worked. Locating them and updating them was tedious, but not particularly difficult.

这篇关于从2005年到2013年升级sql数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！