如何进行SQL Server数据库设置 [英] How to make sql server database setup

问题描述

我有一个使用SQL Server Express的应用程序.如何进行设置以将应用程序安装在客户端计算机上?

我在Google上进行了很多搜索，但没有发现任何帮助.

还尝试了此链接 http://www.codeproject.com/KB/database/Deploy_your_database.aspx

但卡在第3步上.请帮助.

谢谢

Hi,
I have an application that uses SQL Server Express. How to make setup that will install the application on client''s computer?

I searched a lot on google but nothing found helpful.

Also tried this link http://www.codeproject.com/KB/database/Deploy_your_database.aspx

but got stuck on step 3. Please help.

Thanks

推荐答案

在应用程序中确保您的sql server表达为必要条件并选择
从同一位置下载必备软件

when pulishing application ensure you sql server express as prequisite and select
download prequisite from same location

我不完全确定这是否有帮助，但以防万一:

I''m not entirely sure if this will help, but just in case: Xcopy Deployment(SQL Server Express)[^]

您需要还原数据库.

1.安装SQL Express，确保具有文件位置等的所有设置.正确
2.连接到SQL Server Express实例
3.创建一个恢复数据库的SQL脚本
样本:

You need to restore the database.

1. Install SQL Express, make sure to have all the settings for file locations etc. right
2. connect to the SQL Server Express instance
3. create a sql script that restores the database
Sample:

create database myDatabase;
go
RESTORE DATABASE myDatabase
   FROM DISK = 'c:\pathToBackupFile\myDatabase.bak';

在此处查找还原命令的选项:
http://msdn.microsoft.com/en-us/library/ms186858.aspx [ ^ ]

Look here for options of the restore command:
http://msdn.microsoft.com/en-us/library/ms186858.aspx[^]

这篇关于如何进行SQL Server数据库设置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！