how create a installation for a database

how i can create a installation for my server database like the installation of examples northwind

I ask for how i can deploy my database

thanks

Your question is not very clear.

If you are asking how to install and setup SQL Server, then which version do you have in mind? See this link for version differences:

SQL Server 2005 Features, Version Comparison
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

If you need specifc assistance in installing SQL Server, this might help:

SQL Server 2005 Express –Installation Details
http://msdn2.microsoft.com/en-us/library/ms143441.aspx

SQL Server 2005 Express Overview
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp
http://www.pcw.co.uk/personal-computer-world/software/2155087/review-microsoft-sql-server

If you need other information, please try to be more specific in your question so that we can best help you.

Thanks

|||

hi,

you can go with different techniques... you can just "copy" you database's files (data file(s) and transaction log file(s)) into the end-user machine and attach those databases as explained in many articles, and the very same is valid for restoring a prepared database backup onto the end-user machine...

personally I do prefer another approach, similar to the one presented in a great article, where you only deploy DDL schema scripts, DML INSERT/UPDATE scripts.. personally I add plain tex file to be bulk inserted as well for pre-populated table, but the concept is the same..
this method grants you the possibility to maintain your database scripts under source code control, so that your entire production/deployment phase can be verified... better, it grants you the metadata management/upgrade path you will incur with (and it will soon or later ) so that you'll not have to warry abour how to deploy these changes... it also grants you that end-users created databases inherit instance's properties form your customer's specs and not your own, as those db will use the end-user's model database.

all these are "free" ways to do it.. but you can even rely on third party tools, this one is able to produce a self-installing exe, that's to say, once running, it will install new database(s) and even update existing one(s) to the desired metadata schema..

again, personally I go for the "scripts" solution..

regards