将数据从默认的VS 2008 D/B导入到MS SQL 2005 Express Edition [英] Import data from default VS 2008 D/B to MS SQL 2005 express edition

问题描述

大家好，
我是新手，也是第一次做这种工作.

我已经在Visual Studio 2008中创建了一个网站，其中包含Visual Studio提供的数据库.现在，我拥有该数据库，但是我必须部署该网站并使用该数据库作为sql server 2005 Express Edition，因为它是免费的.我有数据库，我该怎么做?我必须在sql server2005 Express Edition中再次制作数据库，请帮助

致谢

hi All,
I am new to this and first time doing this kind of work.

i have created a web site in visual studio 2008 with database provided by the visual studio. Now i have that database but i have to deploy that website and use database as sql server 2005 express edition as it is free. I have the database with me how to do that do i have to make the database again in Sql server2005 express edition please help

Regards and Thanks

推荐答案

您可以使用Visual Studio中的数据库发布向导将数据库发布到您的发布环境.

该工具支持以下方式来部署数据库:

1.它可以生成一个SQL脚本文件，您可以在目标服务器上手动运行该SQL脚本文件以重新创建数据库架构和数据库内容.

2.它可以连接到托管环境提供的Web服务，并将源数据库的内容直接复制到目标数据库.

这是Microsoft在2008年版中使用此向导的教程的链接.

发布SQL数据库 [

You can use the Database publishing wizard in visual studio to publish the database to your release environment.

The tool supports the following ways to deploy a database:

1. It can generate a single SQL script file that you can manually run on the target server to re-create the database schema and the database contents.

2. It can connect to a Web service that is provided by your hosting environment and directly copy the contents of a source database into a target database.

Here is a link to Microsoft''s tutorial on using this wizard in vs 2008

Publishing a SQL Database[^]

这篇关于将数据从默认的VS 2008 D/B导入到MS SQL 2005 Express Edition的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！