Hi,
My client is US based. Now I want to send them the database script for the package installation. Client does'nt have any technical people. So all I have to do it remotely from India. So could any one guide me on this?
thnxDuplicate post. Has been answered in other thread.|||you can send me a check and your worries would all be gonesql
Showing posts with label script. Show all posts
Showing posts with label script. Show all posts
Monday, March 26, 2012
Installing Database
Hi,
My client is US based. Now I want to send them the database script for the package installation. Client does'nt have any technical people. So all I have to do it remotely from India. So could any one guide me on this?
thnxWhat exactly is the problem. Either you can ask them to install by sending the database scripts, or ask them to install a remote server and connect from India remotely. In case of remote connection, they have to open up their server ports to skip the firewall. Then you can connect from India and do everything yourself.|||Could you please come up with a more clear picture, on remote connection and opening the port................?
thnx|||You can install MS Remote Desktop Connection software in your computer and connect to the sql server remotely. For that, you have to ask your client to open you the sql server, http and ftp ports to you.|||They would be crazy to open up ports on their SQL Servers though for you to work on it remotely from India. Just make a backup of a database with only the data needed. They can just restore the database on their SQL Server as part of the installation process. The alternative is to give them a script that creates the database, users, tables, stored procs, etc. and inserts the data needed. That's more prone to error though and harder to troubleshoot.
This is pretty standard practice and you should probably know this if you are going to be distributing commercial applications that utilize SQL Server. You might want to hire a DBA or look at consulting services for your company.|||yup, hire me!
My client is US based. Now I want to send them the database script for the package installation. Client does'nt have any technical people. So all I have to do it remotely from India. So could any one guide me on this?
thnxWhat exactly is the problem. Either you can ask them to install by sending the database scripts, or ask them to install a remote server and connect from India remotely. In case of remote connection, they have to open up their server ports to skip the firewall. Then you can connect from India and do everything yourself.|||Could you please come up with a more clear picture, on remote connection and opening the port................?
thnx|||You can install MS Remote Desktop Connection software in your computer and connect to the sql server remotely. For that, you have to ask your client to open you the sql server, http and ftp ports to you.|||They would be crazy to open up ports on their SQL Servers though for you to work on it remotely from India. Just make a backup of a database with only the data needed. They can just restore the database on their SQL Server as part of the installation process. The alternative is to give them a script that creates the database, users, tables, stored procs, etc. and inserts the data needed. That's more prone to error though and harder to troubleshoot.
This is pretty standard practice and you should probably know this if you are going to be distributing commercial applications that utilize SQL Server. You might want to hire a DBA or look at consulting services for your company.|||yup, hire me!
Friday, February 24, 2012
Installation from AdventureWorks
Hallo
I have reinstalled then SQL-Server.
Now I could found the Script instawdb.sql.
Our version from SQL Server 9.0.2047
and the language is German.
From where could download the script.
Thanks for your help.
Thomas
hi Thomas,
you can get the AdventureWorks install package from http://www.microsoft.com/downloads/details.aspx?FamilyID=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en
regards
Subscribe to:
Posts (Atom)