将SQL 2003转换为2008 [英] Convert sql 2003 to 2008

问题描述

如何将sql 2003转换为sql 2008?
我已经在sql 2003中创建了一些存储过程，现在我想将其转换为sql 2008版本.
请尽快给我回复.

How to convert sql 2003 to sql 2008?
I have created some stored procedures in sql 2003 , now I want to convert it into sql 2008 version.
Please post me the reply as soon as possible.

推荐答案

简单的解决方案是备份旧的db并在sql server 2008下将其还原.
更好的解决方案:为您的数据库和存储过程创建sql脚本，并在sql server 2008上使用sql server management studio执行它们...

问候
Espen Harlinn

Simple solution is to backup old db and restore it under sql server 2008.

Better solution: create sql scripts for your db and stored procedures and execute them using sql server management studio on sql server 2008...

Regards
Espen Harlinn

从旧数据库创建存储过程的脚本，然后在新数据库上运行它们.

Create scripts of Stored procedure from your old DB and then run them on the new one.

没有2003版( SQL Server版本 [

There was not a version 2003 (SQL Server Versions[^]): Do you mean form 2000 or 2005 to 2008?

In any case the stored procedures should run as is: what you might consider is altering them to take advantage of any new features that might be appropriate to each procedure. Without seeing each one there is no way to tell what would be appropriate and, no, I don''t want to see them.

p.s. "Please post me the reply as soon as possible" is considered rude: don''t do it! People will respond as and when they can: it might be urgent to you but who else will care?

这篇关于将SQL 2003转换为2008的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！