如何使用安装屏蔽为Sqlserver 2014设置make？ [英] How do I setup make for Sqlserver 2014 with install shield?

问题描述

我说英语不太好！劳驾。我想用安装盾构建我的项目。

我有一个数据库，但我不知道如何构建设置。

请帮助我！......我是小学的。

内容：

Sqlserver 2014并安装shield 2013和vs 2013.

解决方案

你不应该包含SQL安装中的服务器。有几个原因：

0）您只能出于版权原因分发SQL Server Express - 而不是SQL Server完整版。

1）他们可能已经拥有SQL Server安装在网络上。如果是这样，那么他们可能会想要使用该版本。

2）如果他们确实安装了SQL服务器并且你开始扩散SQL服务器Express实例，那么你将会惹恼数据库管理员...

3）SQl Server的单站点安装比用户控制下的一些分散版本更有可能被备份。

4）对于普通用户来说，安装和管理Sql服务器非常复杂 - 这不是一个好主意！

5）它将破坏使用Sql Server而不是SqlCE或SQLite的主要优势 - 多用户访问。如果每个人都安装了自己的SQL服务器副本，那么您将拥有数据库的多个副本，每个副本由一个人使用。这会引起一些混乱，并且（取决于你如何编写原始数据库）在实现问题时可能需要付出相当大的努力才能组合成单个实例。

首先你是你必须从sql server中分离数据库并将其附加到sqlexpress中。当你想在SSMS（sqlserver管理工作室）中连接服务器时，将它附加在sql express中，设置服务器名称。\ SQLSQLEXPRESS并连接到服务器。之后将数据库附加到该服务器并为您的项目使用此连接字符串



string constring = @Data Source = .\SQLEXPRESS; AttachDbFilename = | DataDirectory | \ MYDATABASE.mdf; Integrated Security = True; User Instance = True;



然后您可以使用此连接字符串测试您的项目。



您可以使用visual studio默认安装程序而不是安装shield。



1-in应用程序文件夹中可以添加调试文件夹数据到那个



2 - 你可以从你的项目exe文件创建一个快捷方式。



3 in in你的项目的先决条件你可以添加.net框架sqlexpress和Windows安装程序和其他东西，如水晶报告运行时引擎

为您的安装包



4 - 您必须构建此解决方案，然后您可以在计算机中运行此项目。



happy codinng

非常坦克............

I can n't speak English very good! Excuse me. I want with install shield build my project.
I have a database but i don't know how build a setup.
please help me!......I am elementary.
contents:
Sqlserver 2014 and install shield 2013 and vs 2013.

解决方案

You should not include SQL Server in your installation. There are a couple of reasons:
0) You can only distribute SQL Server Express for copyright reasons - not SQL Server full version.
1) They may already have SQL Server installed on the network. If so, then they will presumably want to use that version.
2) If they do have SQL server installed and you start proliferating SQL server Express instances, you are going to annoy the heck out of the database administrator...
3) A single site installation of SQl Server is a lot more likely to be backed up than a number of scattered version under user control.
4) Sql server is quite complex for a "normal" user to install and administer - it is not a good idea!
5) It will destroy the primary advantage of using Sql Server over SqlCE or SQLite - multiuser access. If everyone installs their own copy of SQL server, then you will have multiple copies of your database, each used by a single person. This will cause some confusion, and (depending on how you wrote the original database) may take some considerable effort to combine into a single instance when the problem is realized.

first of all you you must detach your database from your sql server and attach it in sqlexpress. for attaching it in sql express when you want to connect to server in SSMS(sqlserver management studio) set server name .\SQLSQLEXPRESS and connect to server. after that attach your database to that server and use this connection string for your project

string constring = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MYDATABASE.mdf;Integrated Security=True;User Instance=True";

then you can test your project with this connection string.

you can use visual studio default installer instead of install shield.

1-in application folder you can add your debug folder data's to that

2-you can create a shortcut from your project exe file.

3- in the prerequisties of your project you can add .net framework sqlexpress and windows installer and other things like crystal report runtime engine
for your installation package

4-you must build this solution and you can run this in and ccomputer that you want

happy codinng

tank you very much............

这篇关于如何使用安装屏蔽为Sqlserver 2014设置make？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！