sql server 2005到sql server 2008迁移工具 [英] sql server 2005 to sql server 2008 migration tool

问题描述

嘿，我想将sql server 2005数据库迁移到sql server 2008数据库。我怎样才能做到这一点？ 2005数据库还包含了在sql server 2008中也需要迁移的存储过程和功能。最好的帖子肯定可以理解

Hey i want to migrate the sql server 2005 database to sql server 2008 database. how can i do this? the 2005 database also contains the store procedure and functioni need to migrate that too in sql server 2008. best post are surely appreciable

推荐答案

你可以直接将mdf附加到sql server 2008.

As

http://www.packtpub.com/article/moving-a-database-from-sql-server-2005-to-sql-server-2008-in - 三步 [ ^ ]



或



您可以将SQL Server实例升级到SQL Server 2008.



http://technet.microsoft.com/en-us/library/dd335967(v=office.12).aspx [ ^ ]

You can directly attach mdf to sql server 2008.
As
http://www.packtpub.com/article/moving-a-database-from-sql-server-2005-to-sql-server-2008-in-three-steps[^]

or

You can upgrade SQL server instance to SQL server 2008.

http://technet.microsoft.com/en-us/library/dd335967(v=office.12).aspx[^]

数据库迁移SQL 2005到SQL 2008 [ ^ ]

这两个解决方案都很受欢迎，但我不需要手动迁移我需要一个工具来迁移2005年到2008年。例如，我们希望将访问数据库迁移到sql server意味着我们使用SSMA工具进行迁移。我们如何通过工具将sql server 2005迁移到2008年。

Both the solutions are appreciated but i don''t do this migration manually i need a tool to migrate 2005 to 2008. for example we want to migrate access database to sql server mean we use SSMA tool for migration. In the same way how we can migrate the sql server 2005 to 2008 by a tool.

这篇关于sql server 2005到sql server 2008迁移工具的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！