Sql Server express 2005部署 [英] Sql Server express 2005 deployment
问题描述
我在VS.NET 2005中开发一个Windows应用程序。该应用程序是数据库驱动的
我需要将它部署在一个客户的电脑。关于开发这样一个应用程序，我该怎么办？b $ b。我记得我做过一次很长的事情
回来..比如将.mdf文件包含在我的项目中的解决方案资源管理器中，然后使用Click Once部署工具。确保在客户端安装我的应用程序时创建了
数据库和表格。
现在我好像忘记了程序，找不到任何其他的
资源。如果有人能引导我完成它，我将非常感激。
我是否必须创建.mdf文件或SQL Sever 2005自动创建
一个我创建了一个数据库。如果是，它在哪里保存文件。然后
拥有现有的.mdf文件后的下一步是什么...
谢谢。
Hi,
I am developing a windows application in VS.NET 2005. The application is
database driven and I need to deploy it on a client''s pc. How should I go
about developing such an application. I remember I did something once long
back .. like including .mdf files into my project in the solution explorer of
VS 2005 and then used Click Once deployment tool ... to make sure that the
database and tables were created when the client installed my application.
Now I seem to have forgotten the procedure and cannot find any other
resource. Iwould be really grateful if someone could guide me through it.
Do I have to create a .mdf file or does SQL Sever 2005 automatically create
one when I create a database. If yes where does it save the file. And then
what are the next steps after having an existing .mdf file...
Thank you.
推荐答案
>
我是否必须创建.mdf文件或执行SQL Sever 2005年我创建数据库时自动创建
。如果是，它在哪里保存文件。然后
拥有现有的.mdf文件之后的下一步是什么...
>
Do I have to create a .mdf file or does SQL Sever 2005 automatically
create
one when I create a database. If yes where does it save the file. And then
what are the next steps after having an existing .mdf file...
MDF和LDF文件将是位于Program Files / Microsoft Sql
Server / MSSQL.1 / MSSQL / DATA。
至于其他部分关于部署的东西。使用MS的网络解决方案
Sql Server Express，我在谷歌上发表文章，显示
如何。
The MDF and LDF files are going to be located at Program Files/Microsoft Sql
Server/MSSQL.1/MSSQL/DATA.
As far as the rest of the stuff about deployment of a .Net solution using MS
Sql Server Express, I ran across articles out there on Google showing the
how to.
雅我试图这样做...转到文件夹并选择mdf文件....
它说错误发生了......明天我会试着收获。
谢谢
" Mr。阿诺德"写道：
Ya I tried to do that... going to the folder and selecting the mdf file....
it said "An error occurred"... i will try it gain tomorrow.
Thank you
"Mr. Arnold" wrote:
>
>
我是否必须创建.mdf文件或自动执行SQL Sever 2005
创建
当我创建数据库时。如果是，它在哪里保存文件。然后
拥有现有.mdf文件之后的下一步是什么...
Do I have to create a .mdf file or does SQL Sever 2005 automatically
create
one when I create a database. If yes where does it save the file. And then
what are the next steps after having an existing .mdf file...
MDF和LDF文件将是位于Program Files / Microsoft Sql
Server / MSSQL.1 / MSSQL / DATA。
至于其他部分关于部署的东西。使用MS的网络解决方案
Sql Server Express，我在谷歌上发表文章，显示
如何。
The MDF and LDF files are going to be located at Program Files/Microsoft Sql
Server/MSSQL.1/MSSQL/DATA.
As far as the rest of the stuff about deployment of a .Net solution using MS
Sql Server Express, I ran across articles out there on Google showing the
how to.
如果要使用项目部署sql数据库，则需要对数据库进行
备份。进行备份时，请创建mdf和
ldf文件。获取这些副本并将其与您的应用程序一起部署在SQL运行时，
无法复制mdf或ldf文件。你需要先停止
SQL Server流程。
Adrian。
[请注明我的答案，如果它对你很有帮助]
" Punit Kaur"写道：
When you want to deploy your sql database with a project, you need to make a
backup of your database. When you make the back up, create the mdf and the
ldf files. Take these copies and deploy them with your application. You
cannot copy the mdf or ldf files while SQL is running. You need to stop the
SQL Server process before you can do that.
Adrian.
[Please mark my answer if it was helpful to you]
"Punit Kaur" wrote:
>
Ya我试图这样做...转到文件夹并选择mdf文件....
它说发生错误......明天我会试着收获。
谢谢
先生。阿诺德"写道：
>
Ya I tried to do that... going to the folder and selecting the mdf file....
it said "An error occurred"... i will try it gain tomorrow.
Thank you
"Mr. Arnold" wrote:
>
我是否必须创建.mdf文件或执行SQL Sever 2005当我创建数据库时，自动创建
。如果是，它在哪里保存文件。然后
拥有现有的.mdf文件之后的下一步是什么...
>
>
Do I have to create a .mdf file or does SQL Sever 2005 automatically
create
one when I create a database. If yes where does it save the file. And then
what are the next steps after having an existing .mdf file...
>
MDF和LDF文件将位于Program Files / Microsoft Sql
/ Server / MSSQL.1 / MSSQL / DATA。
至于其他有关使用MS部署.Net解决方案的内容的问题，我在Google上展示了一些文章
如何。
The MDF and LDF files are going to be located at Program Files/Microsoft Sql
Server/MSSQL.1/MSSQL/DATA.
As far as the rest of the stuff about deployment of a .Net solution using MS
Sql Server Express, I ran across articles out there on Google showing the
how to.
这篇关于Sql Server express 2005部署的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
