How to get SQL data from another one computer? |
| |
|
|
|
New Poster Posts: 2 Topics: 2
|
|
|
August 26, 2010, 11:14:08 PM
|
|
How to get SQL data from another one computer?
how can i transfer my sql database from my one PC to Laptop?
_______________________________
Funeral Insurance|Funeral Cover
|
|
| |
|
|
|
Code Guru
Location: India
Gender:  Posts: 1387 Topics: 105
 
|
|
|
September 03, 2010, 04:36:59 AM
|
|
Well there are some pretty simple steps for moving your database from one PC to another one:
1) backup your database. The backup file should be with extension .bak
2) move this backup file from your PC to other PC.
3) Restore this backup to this new PC
If backing up database is not working then, you can
1) Copy the database files from one machine to other machine. These files would be with extension .mdf and .ldf
The .mdf is the main database file and the .ldf is the log file. Copying only .mdf should also do in such cases.
2) Attach this .mdf file to the SQL on other machine.
If you right click on the main database displayed in the SQL management console, you will see an option "Attach database". Make use of this and follow the steps given.
Hope this helps you.
|
|
| |
|
|
|
Code Guru Gender: Posts: 1399 Topics: 85
|
|
|
September 06, 2010, 12:17:38 PM
|
|
Depends on the DB - most (none Access) ship with migration tools which you can use.
|
|
| |
|
|
|
New Poster Real name: John Blake
Gender:
Posts: 7 Topics: 3
|
|
|
September 21, 2010, 03:05:47 AM
|
|
I m agree with Code Guru's reply.
|
|
| |
|
|
|
|
New Coder Posts: 44 Topics: 0
|
|
|
March 24, 2011, 10:34:20 PM
|
|
Thanks for this stepwise information.
|
|
| |
|
|
|
|
Professional Coder Gender:  Posts: 242 Topics: 3
|
|
|
July 18, 2011, 08:53:35 AM
|
|
is this possible..?
|
|
| |
|
|
|
|
Regular Coder Posts: 93 Topics: 34
|
|
|
August 18, 2011, 11:07:39 PM
|
|
HI,
ya its a possible and nice and accurate information given by you step by step.
Thanks for sharing.
|
|
| |
|
|
|
|
New Poster Posts: 1 Topics: 0
|
|
|
August 24, 2011, 02:25:58 PM
|
|
For solving out given condition you may use sql database recovery. It has some important features such as working with mdf files up to 16TB. The tool starts under low system requirements.
|
|
| |
|
|
|
Regular Coder Gender:
Posts: 87 Topics: 31
|
|
|
November 19, 2011, 04:42:06 AM
|
|
It depend on size of data base.
|
|
| |
|
|
|
New Poster Gender: Posts: 1 Topics: 0
|
|
|
November 30, 2011, 06:29:35 AM
|
|
The best solution is to create a backup of your current database and then fresh install the MS SQL application and restore the data again so that the problem will be fixed. To do this you should use professional SQL Database Recovery Software. The software is built to create the backup of the file without any trouble and in any condition. It works by recovering the data from the corrupted MS SQL Database too. So its a wonderful solution for getting the data back because after all, its the data which is precious.
|
|
| |
