How to get SQL data from another one computer? |
| |
 |
Reputation Power: 1
| | 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
|
|
|
|
| |
 |
Reputation Power: 19
| | Code Guru Location: India
Gender:  Posts: 1456 Topics: 135  
 |
|
|
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.
Help us to keep this forum clean. Report the SPAM!
|
|
| |
 |
Reputation Power: 17
| | Code Guru Gender: Posts: 1403 Topics: 86 |
|
|
September 06, 2010, 12:17:38 PM
|
Depends on the DB - most (none Access) ship with migration tools which you can use.
|
|
| |
 |
Reputation Power: 1
| | New Poster Real name: John Blake
Gender:
Posts: 6 Topics: 2 |
|
|
September 21, 2010, 03:05:47 AM
|
I m agree with Code Guru's reply.
|
|
| |
|
Reputation Power: 1
| | New Coder Posts: 44 Topics: 0 |
|
|
March 24, 2011, 10:34:20 PM
|
Thanks for this stepwise information.
|
|
| |
|
Life Is Good!
Reputation Power: 3
| | Professional Coder Gender:  Posts: 241 Topics: 3 |
|
|
July 18, 2011, 08:53:35 AM
|
is this possible..?
|
|
| |
|
Reputation Power: 2
| | 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.
|
|
| |
|
Reputation Power: 1
| | 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.
|
|
| |
 |
Biz
Reputation Power: 2
| | Regular Coder Gender:
Posts: 87 Topics: 31 |
|
|
November 19, 2011, 04:42:06 AM
|
It depend on size of data base.
|
|
| |
 |
Reputation Power: 1
| | 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.
|
|
| |
|
Reputation Power: 5
| | Professional Coder Posts: 244 Topics: 85 |
|
|
February 29, 2012, 10:53:31 PM
|
copy backup files to other machines and then attach the database to MySql..
|
|
| |
TechnicalTalk » Programming and Web Development » Database Programming Discussions » How to get SQL data from another one computer?
