Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Database Deployment

Author  Topic 

kishoreg
Starting Member

11 Posts

Posted - 2010-03-29 : 05:41:01
Hi, I have developed an Asp.Net application with backend sqlserver 2008 database. Now i want to install the MSI file in client system along with database file.
In client system i want to install the sqlserver with out any sql editor.The sqlserver shouldn't use for development purpose. The sqlserver must acts just like engine between application and database file. In sqlserver which file i have to install in client system to do the above things ?

amitranjan
Starting Member

45 Posts

Posted - 2010-03-29 : 05:46:32
First of all such type of question you have to ask on asp.net forums. But here is your solutions.If application is developed in SqlServer or Express edition you , must need Database Engine installed at the machine where you are deploying the application. You cannot access mdf (sql server)file as mdb (ms access database) files. And regarding the script that will automatically create database on server , create it from ManagementStudio. You need some line of code to automate the process while installation.

Hope this will help

amit Ranjan
Go to Top of Page

kishoreg
Starting Member

11 Posts

Posted - 2010-03-29 : 06:33:03
Hi, Thanks for your response. Can you provide any link to explain the above in detail ?
Go to Top of Page

amitranjan
Starting Member

45 Posts

Posted - 2010-03-29 : 06:37:02
quote:
Originally posted by kishoreg

Hi, Thanks for your response. Can you provide any link to explain the above in detail ?



for install script check DotNetNuke or or nopCommerce , on http://www.asp.net or on the same link goto forums, http://forums.asp.net

amit Ranjan
Go to Top of Page

amitranjan
Starting Member

45 Posts

Posted - 2010-03-29 : 06:38:19
quote:
Originally posted by amitranjan

quote:
Originally posted by kishoreg

Hi, Thanks for your response. Can you provide any link to explain the above in detail ?



for install script check DotNetNuke or or nopCommerce , on http://www.asp.net or on the same link goto forums, http://forums.asp.net

amit Ranjan



http://forums.asp.net/26.aspx

amit Ranjan
Go to Top of Page
   

- Advertisement -