how can i create a setup file to setup a project which includes SQL database, and Analysis services database.
which this file, i can go to any machine have SQL Server 2005 (Analysis Services). and run it to install my program, it also install database SQL and database of Analysis services. don't need to do anything else.


How can i do, and can you show mw to do it, i need to do it as soon as possible
thanks

You can include the database files (.MDF, .LDF) files in your installation and attach them to any instance of the SQL server database using a custom action. You can use OSQL utility or SQL DMO API to attach the database. Here is how:

• Administering SQL Server Using osql
• Developing SQL-DMO Applications
• SQL-DMO Reference
• VS Script to attach a database with MSDE / SQL Server.

Let me know if this solves your problem.

Regards,

Muhammad Ghaznavi

You can include the database files (.MDF, .LDF) files in your installation and attach them to any instance of the SQL server database using a custom action. You can use OSQL utility or SQL DMO API to attach the database. Here is how:

• Administering SQL Server Using osql
• Developing SQL-DMO Applications
• SQL-DMO Reference
• VS Script to attach a database with MSDE / SQL Server.

Let me know if this solves your problem.

Regards,

Muhammad Ghaznavi