Database Setup Tool

I was wondering if Microsoft SQL server has any tools that will will generate a setup.exe file to install the database on a seperate SQL server. I can see that you can script the entire database however it does not detect the dependencies in the correct order and hence I have to manually go through the script file and modify the creation order manually.

If we can generate a setup file

1) Network Admins who are installing the application and who have no idea of user SQL server can easily set up the database

2) I dont need to show the code for the sp, views etc as we can encrypt the code (I know it can be decrypted but that is ok)

I found tools from other vendors which we have to purchase to achive this.... Does MS Sql server have such a utility or is there any free utility that does this?

i guess u need to transfer database from one server to another. if this is the requirement , there are two methods

(a) Backup /restore

(b) detach/attach

You can automate it. If you have tried this pse let us know what is the difficulties u faced. Scripting database is not a complete solution.

pse refer BOL or post back if you are not clear with these terms

Madhu

|||

thanks Madhu.

But i only want to transfer the database structure ... not the data within it. If I do a backup / restore or detach / attach, it will take the data + transaction logs along with it. I can script the data + transaction logs to be cleared before doing the backup. But I dont want the data to be cleared in my environment as it has a lot of test data that has taken months to do. Alternatively i have to take another backup before clearing the data.

All this is going to be untidy. So that is why I was looking for a setup utility as I have seen other applications do this.

|||

if you asked the tool available ... then the answer may be Visio. Visio can easily handle these kind of scenario. As such there should not be any problem in Scripting from SQL Server also. Could you please tell us what is the problem u faced when u script the object using Management stuido and runing it in target server.

Redgate and all have tools for these kind of activities. But i strongly feel that SQL Server inbuilt features can easily handle this issue.

Also post back the result of Select @.@.version .

Madhu

Database services install fails when install SQL server 2005 SP2

The error I got is:

Hotfix.exe has encountered a problem and needs to close. We are sorry for the inconvenience.

EventType : sqlsesetup P1 : sysdbupg.sql P2 : 0x7361
P3 : odbcstatement__execute_batch@.sysdbupg.sql@.3 P4 : 0x7361
P5 : lib_odbc_statement.h@.91 P6 : unknown P7 : sql9 P8 : hotfix@.
P9 : x86 P10 : 3042

Log Location: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log

MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.

I tried to search internet, however, I couldn't get solution.

My SQL server 2005 is standard version, OS Windows server 2003 sp2, I am using Administrator account to install it.

Thanks a lot,

Rex

Nobody answer my question yet

I am wondering it is caused by Windows server sp2? I saw the requirement to install SQL server sp2 is the OS is windows server 2003 sp1, my current version is Window server 2003 standard sp2, will this cause the problem? any microsoft professional has any idea of it?

Thanks,

Rex

|||

You can refer this link, http://support.microsoft.com/kb/918695 but it provides a solution for SQL 2005 SP1 installation.....just ensure that the master and resource database fiels reside in the same location prior to installing SQL 2005 SP2.......its just a suggestion, i am not sure this will solve your problem but you can give a try and revert back..........

|||

Thanks for relpy, my database files are all in default location where master database are, this link doesnt solve my problem.

Thanks anyway.

Deepak Rangarajan wrote:

You can refer this link, http://support.microsoft.com/kb/918695 but it provides a solution for SQL 2005 SP1 installation.....just ensure that the master and resource database fiels reside in the same location prior to installing SQL 2005 SP2.......its just a suggestion, i am not sure this will solve your problem but you can give a try and revert back..........

|||

The server time is wrong, for some reason, our sys admin guy set it to 2003, he reset the time, and reinstall the sp2 without selecting any feature, now, I installed it again with all features selected, it works now.

Thanks,

Rex

|||Rex,

Thx for your reply, this really help others to check those silly mistakes.

Database services install fails when install SQL server 2005 SP2

The error I got is:

Hotfix.exe has encountered a problem and needs to close. We are sorry for the inconvenience.

EventType : sqlsesetup P1 : sysdbupg.sql P2 : 0x7361
P3 : odbcstatement__execute_batch@.sysdbupg.sql@.3 P4 : 0x7361
P5 : lib_odbc_statement.h@.91 P6 : unknown P7 : sql9 P8 : hotfix@.
P9 : x86 P10 : 3042

Log Location: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log

MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.

I tried to search internet, however, I couldn't get solution.

My SQL server 2005 is standard version, OS Windows server 2003 sp2, I am using Administrator account to install it.

Thanks a lot,

Rex

Nobody answer my question yet

I am wondering it is caused by Windows server sp2? I saw the requirement to install SQL server sp2 is the OS is windows server 2003 sp1, my current version is Window server 2003 standard sp2, will this cause the problem? any microsoft professional has any idea of it?

Thanks,

Rex

|||

You can refer this link, http://support.microsoft.com/kb/918695 but it provides a solution for SQL 2005 SP1 installation.....just ensure that the master and resource database fiels reside in the same location prior to installing SQL 2005 SP2.......its just a suggestion, i am not sure this will solve your problem but you can give a try and revert back..........

|||

Thanks for relpy, my database files are all in default location where master database are, this link doesnt solve my problem.

Thanks anyway.

Deepak Rangarajan wrote:

You can refer this link, http://support.microsoft.com/kb/918695 but it provides a solution for SQL 2005 SP1 installation.....just ensure that the master and resource database fiels reside in the same location prior to installing SQL 2005 SP2.......its just a suggestion, i am not sure this will solve your problem but you can give a try and revert back..........

|||

The server time is wrong, for some reason, our sys admin guy set it to 2003, he reset the time, and reinstall the sp2 without selecting any feature, now, I installed it again with all features selected, it works now.

Thanks,

Rex

|||Rex,

Thx for your reply, this really help others to check those silly mistakes.

Database services install fails when install SQL server 2005 SP2

The error I got is:

Hotfix.exe has encountered a problem and needs to close. We are sorry for the inconvenience.

EventType : sqlsesetup P1 : sysdbupg.sql P2 : 0x7361
P3 : odbcstatement__execute_batch@.sysdbupg.sql@.3 P4 : 0x7361
P5 : lib_odbc_statement.h@.91 P6 : unknown P7 : sql9 P8 : hotfix@.
P9 : x86 P10 : 3042

Log Location: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log

MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.

I tried to search internet, however, I couldn't get solution.

My SQL server 2005 is standard version, OS Windows server 2003 sp2, I am using Administrator account to install it.

Thanks a lot,

Rex

Nobody answer my question yet

I am wondering it is caused by Windows server sp2? I saw the requirement to install SQL server sp2 is the OS is windows server 2003 sp1, my current version is Window server 2003 standard sp2, will this cause the problem? any microsoft professional has any idea of it?

Thanks,

Rex

|||

You can refer this link, http://support.microsoft.com/kb/918695 but it provides a solution for SQL 2005 SP1 installation.....just ensure that the master and resource database fiels reside in the same location prior to installing SQL 2005 SP2.......its just a suggestion, i am not sure this will solve your problem but you can give a try and revert back..........

|||

Thanks for relpy, my database files are all in default location where master database are, this link doesnt solve my problem.

Thanks anyway.

Deepak Rangarajan wrote:

You can refer this link, http://support.microsoft.com/kb/918695 but it provides a solution for SQL 2005 SP1 installation.....just ensure that the master and resource database fiels reside in the same location prior to installing SQL 2005 SP2.......its just a suggestion, i am not sure this will solve your problem but you can give a try and revert back..........

|||

The server time is wrong, for some reason, our sys admin guy set it to 2003, he reset the time, and reinstall the sp2 without selecting any feature, now, I installed it again with all features selected, it works now.

Thanks,

Rex

|||Rex,

Thx for your reply, this really help others to check those silly mistakes.
sql