create an installer for sql server 2005 db

Can anyone tell how can I create an installer for sql server database.

What do you mean with an installer for sql databases?

|||

The two popular methods to package a database are:

1. as empty database backup file

2. as a t-sql script

Microsoft actually employs the second method for their database deployment. You can take a look at "C:\Program Files\Microsoft SQL Server\MSSQL\Install\instnwnd.sql" file for an example of Northwind database delivery.

|||

I am desigining a small database for my application. The users who use my application, I want to let them install the sql database too. Just like .msi packages u have for web applications, where you get the gui to install the application, I am wondering if you can do the same way or some other better approach to do this.

|||

Take a look at sqlexpress redistribution.

http://www.microsoft.com/sql/editions/express/redistregister.mspx

create an installer for sql server 2005 db

Can anyone tell how can I create an installer for sql server database.

What do you mean with an installer for sql databases?

|||

The two popular methods to package a database are:

1. as empty database backup file

2. as a t-sql script

Microsoft actually employs the second method for their database deployment. You can take a look at "C:\Program Files\Microsoft SQL Server\MSSQL\Install\instnwnd.sql" file for an example of Northwind database delivery.

|||

I am desigining a small database for my application. The users who use my application, I want to let them install the sql database too. Just like .msi packages u have for web applications, where you get the gui to install the application, I am wondering if you can do the same way or some other better approach to do this.

|||

Take a look at sqlexpress redistribution.

http://www.microsoft.com/sql/editions/express/redistregister.mspx

sql

CR Out of Memory Error

I am using VB6(SP6) / CR(8.0.1) / WISE INSTALLER(8.1) to distribute a small program. The data is all contained in MS Access 2000 tables and I am using ADO to create each report recordset.

In CR designer I use a TTX file to design the report. This TTX file contains all colums from the recordset and their descriptions i.e. Name, Type, Length and example data.

I create a distribution CD using Wise Installer. Once installed on a Win98, Win2000, Win XP computer everything runs great until the user attempts to run any of the CR reports. On screen the SQL query runs and then calls the CR report. The CR viewer appears and immediately we get an "Out of Memory" error response from CR.

My only remedy is to install MS Office Pro or MS Access 2000-2002. I have use (paid for support) at VB, CR and Wise and received no fix for this problem. VB says it CR, CR says its VB and Wise simply doesn't know?

Thanks in advance for any help on this problem...Maybe you have a memory leak in your VB program?|||Don't think this is the problem... as installing access or office pro solves the problem. This could not fix a memory leak inside the vb program. This problem only occurs if we install to a new computer..

Thanks for your reply