Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
I have developed application on C# desktop application with SQL 2005 as back end. I installed the application on an admin pc and also on my laptop computer, the laptop computer access the admin pc which is on the same network for the DB. However, is there any way I could restore the admin PC Database to My Laptop so that I can view data by connecting to the SQL on my comp when I am out of the network? Right now the scenario is defined as: any computer on the network has to access the DB from the admin PC in order to access any data and if any PC(laptop) within the network goes out of the network, the application wont work since there is no local DB, so how can I import and restore the DB frm the Admin PC wen I am on the network and restore it to my comp for future viewing.. Please Help.
Posted 15-Apr-13 19:48pm

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

create a backup of your network db and restore the backup on your local system.
 
But if you dont have sql server on your localsystem (many people have sql express) then you have to create the scripts in n/w db and execute them locally.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 565
1 Maciej Los 319
2 Richard MacCutchan 220
3 BillWoodruff 164
4 Mathew Soji 160
0 OriginalGriff 8,654
1 Sergey Alexandrovich Kryukov 7,407
2 DamithSL 5,639
3 Maciej Los 5,229
4 Manas Bhardwaj 4,986


Advertise | Privacy | Mobile
Web02 | 2.8.1411023.1 | Last Updated 16 Apr 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100