Export DB from Sql Server 2005 Express
-
-
I have Sql Server 2005 Express installed in my PC and have some database in it. I also have a Laptop where I installed Sql Server 2005 Express too. Is possible to transfer the databases from the my desktop PC to the laptop Sql Server 2005 Express?
Make a backup on your PC then restore it to the laptop.
Upcoming events: * Glasgow: SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services... Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website
-
I have Sql Server 2005 Express installed in my PC and have some database in it. I also have a Laptop where I installed Sql Server 2005 Express too. Is possible to transfer the databases from the my desktop PC to the laptop Sql Server 2005 Express?
You could also detach the database and then copy the mdf and ldf files over to the new machine. You will have to reattach the files on the main machine and the laptop. The whole point of detach and reattach is to provide a means to share databases and it is allot simpler than backing up and restore method.
_____________________________________________________________________ Our developers never release code. Rather, it tends to escape, pillaging the countryside all around. The Enlightenment Project (paraphrased comment) Visit Me at GISDevCafe
-
You could also detach the database and then copy the mdf and ldf files over to the new machine. You will have to reattach the files on the main machine and the laptop. The whole point of detach and reattach is to provide a means to share databases and it is allot simpler than backing up and restore method.
_____________________________________________________________________ Our developers never release code. Rather, it tends to escape, pillaging the countryside all around. The Enlightenment Project (paraphrased comment) Visit Me at GISDevCafe
Aaron VanWieren wrote:
The whole point of detach and reattach is to provide a means to share databases
Move, not share. The whole point of a server based database system is that you don't end up with multiple copies of a database and end up with a complete mess because you no longer know which is the definitive version. This happens a lot with Access.
Aaron VanWieren wrote:
it is allot simpler than backing up and restore method
Well, with backup and restore you only have one file to deal with. With detach and attach you have to deal with a minimum of two files and, depending on how your database is set up, it could be a lot more than that. Not only that but the database could span various disks. Heck, it is even possible that SQL Server just takes over an entire disk - so there are no files to detach at all, just a physical disk.
Upcoming events: * Glasgow: SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services... Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website
-
Aaron VanWieren wrote:
The whole point of detach and reattach is to provide a means to share databases
Move, not share. The whole point of a server based database system is that you don't end up with multiple copies of a database and end up with a complete mess because you no longer know which is the definitive version. This happens a lot with Access.
Aaron VanWieren wrote:
it is allot simpler than backing up and restore method
Well, with backup and restore you only have one file to deal with. With detach and attach you have to deal with a minimum of two files and, depending on how your database is set up, it could be a lot more than that. Not only that but the database could span various disks. Heck, it is even possible that SQL Server just takes over an entire disk - so there are no files to detach at all, just a physical disk.
Upcoming events: * Glasgow: SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services... Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website
Good points. Sorry in the over simplification. It really depends on the database specifics.
_____________________________________________________________________ Our developers never release code. Rather, it tends to escape, pillaging the countryside all around. The Enlightenment Project (paraphrased comment) Visit Me at GISDevCafe
-
Make a backup on your PC then restore it to the laptop.
Upcoming events: * Glasgow: SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services... Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website
Colin Angus Mackay wrote:
Make a backup on your PC then restore it to the laptop.
Is this a better method than detach and attach?
"We are all repositories for genetically-encoded information that we're all spreading back and forth amongst each other, all the time. We're just lousy with information." - Neal Stephenson
-
Colin Angus Mackay wrote:
Make a backup on your PC then restore it to the laptop.
Is this a better method than detach and attach?
"We are all repositories for genetically-encoded information that we're all spreading back and forth amongst each other, all the time. We're just lousy with information." - Neal Stephenson
Jerry Hammond wrote:
Is this a better method than detach and attach?
I would say so. Apart from anything else, you only have one file to transfer.
Upcoming events: * Glasgow: SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services... Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website
-
Jerry Hammond wrote:
Is this a better method than detach and attach?
I would say so. Apart from anything else, you only have one file to transfer.
Upcoming events: * Glasgow: SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services... Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website
Thanks. My knee-jerk thought was to detach and attach, but upon reading your explanation further down in this thread I undertsand now why it would not be the optimum choice of action.
"We are all repositories for genetically-encoded information that we're all spreading back and forth amongst each other, all the time. We're just lousy with information." - Neal Stephenson