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: 1227 Topics: 95
|
|
|
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: 1296 Topics: 79
|
|
|
September 06, 2010, 12:17:38 PM
|
|
Depends on the DB - most (none Access) ship with migration tools which you can use.
|
|
| |
