| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2011-12-12 : 03:01:29
|
| Hi,There is a simple windows application which connects to sql server express database. This app and sql server express are installed on a single pc.This pc is on the network but there is no remote login from outside of the organization.Question:1- Is there any way to connect to this machine from home (Home users only want to read data)?2- If the answer to question 1 is no, then how about each user (Only a small number of users work from home) having sql server expressed in their home pc and using the .bak file of the master sql server in the organization each time.What do you think please?Thanks |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-12-13 : 01:43:49
|
| 1) Can they Remote Desktop?2) This step is possible - you could esaily set up a job - that backs the databases , transfers the backup and restores on the users machine. Use a combination of Powershell and SQLCMD to manage the processJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
lappin
Posting Yak Master
182 Posts |
Posted - 2011-12-13 : 11:22:25
|
| You could let users read data via webpage which reads database |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-12-13 : 17:31:06
|
quote:
Originally posted by lappin
You could let users read data via webpage which reads database
Can not develop a web app because a windows app is already present.Thanks |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-12-13 : 17:32:28
|
quote:
Originally posted by jackv
1) Can they Remote Desktop?2) This step is possible - you could esaily set up a job - that backs the databases , transfers the backup and restores on the users machine. Use a combination of Powershell and SQLCMD to manage the processJack Vamvas--------------------http://www.sqlserver-dba.com
If it is ok, please elaborate point 2. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-12-14 : 01:45:37
|
| On your source database take a scheduled backup onto a local diskTransfer the file on to the user laptops, and restore.To transfer use - a command line script -Powershell is an example. To Restore - use SQLCMD.You mentioned the source database is Express- so this shouldn't be a problem , if you're restoring onto the same Edition - versionJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-12-14 : 03:58:37
|
quote:
Originally posted by jackv
On your source database take a scheduled backup onto a local diskTransfer the file on to the user laptops, and restore.To transfer use - a command line script -Powershell is an example. To Restore - use SQLCMD.You mentioned the source database is Express- so this shouldn't be a problem , if you're restoring onto the same Edition - versionJack Vamvas--------------------http://www.sqlserver-dba.com
1- On the main machine, I can get a .bak onto a usb stick2- send this .bak to the user. The users who use their machines at home (For reading data only) are not IT literate. So, what is the easiest way I can set something up for them to restore this.bak file into their sql server express 2005 local machine ?Thanks |
|
|
|
lappin
Posting Yak Master
182 Posts |
Posted - 2011-12-15 : 04:24:17
|
| Backup to SQL Azure is another option, plus give you additional redundancy. |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-12-15 : 09:33:18
|
| I think for me the best thing to do is, backup the database, send the .bak to the home user, home user then restores onto their local sql server express. If they do not know how to do this then I can remote connect to their machine and do this. |
|
|
|
|
read database