Exporting a database
-
Hi, I would like to export a database I use at work to test at home. I'm wondering if there is a way to export it so the whole database is stored as a file, and you can connect to the file as if it was the SQL server (I cant access the SQL server from home). Is something like this possible? I am running SQL Server Management Studio 2005. Cheers,
Mark Brock "We're definitely not going to make a G or a PG version of this. It's not PillowfightCraft." -- Chris Metzen
-
Hi, I would like to export a database I use at work to test at home. I'm wondering if there is a way to export it so the whole database is stored as a file, and you can connect to the file as if it was the SQL server (I cant access the SQL server from home). Is something like this possible? I am running SQL Server Management Studio 2005. Cheers,
Mark Brock "We're definitely not going to make a G or a PG version of this. It's not PillowfightCraft." -- Chris Metzen
Hi, you could use the SQL Server 2005 Express Edition at home. It is free to use... Then just create a complete backup at work and restore it at home. Regards Sebastian
It's not a bug, it's a feature! Check out my CodeProject article Permission-by-aspect. Me in Softwareland.
-
Hi, I would like to export a database I use at work to test at home. I'm wondering if there is a way to export it so the whole database is stored as a file, and you can connect to the file as if it was the SQL server (I cant access the SQL server from home). Is something like this possible? I am running SQL Server Management Studio 2005. Cheers,
Mark Brock "We're definitely not going to make a G or a PG version of this. It's not PillowfightCraft." -- Chris Metzen
Yes. Use the copy database wizard.
“If you think you are worth what you know, you are very wrong. Your knowledge today does not have much value beyond a couple of years. Your value is what you can learn and how easily you can adapt to the changes this profession brings so often.”-– Jose M. Aguilar
-
Hi, I would like to export a database I use at work to test at home. I'm wondering if there is a way to export it so the whole database is stored as a file, and you can connect to the file as if it was the SQL server (I cant access the SQL server from home). Is something like this possible? I am running SQL Server Management Studio 2005. Cheers,
Mark Brock "We're definitely not going to make a G or a PG version of this. It's not PillowfightCraft." -- Chris Metzen
Just run backup... Run this script in your office computer :
BACKUP DATABASE [db] TO DISK = N'c:\Backup\db.bak' WITH NOFORMAT, NOINIT, NAME = N'db-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GOIt will produce an output
db.bakin your localC:\backupfolder. [Please replace db with your database name on the script.] Now in home run this :RESTORE DATABASE [db] FROM DISK = N'C:\Backup\DB.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10
GOHere db is the name of the database it will create when it restores, place the db.bak file from your office to your home computer in C:\backup or whatever you like to and finally run it.. :cool::cool:
Abhishek Sur
My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB
**Don't forget to click "Good Answer" if you like to.
-
Hi, I would like to export a database I use at work to test at home. I'm wondering if there is a way to export it so the whole database is stored as a file, and you can connect to the file as if it was the SQL server (I cant access the SQL server from home). Is something like this possible? I am running SQL Server Management Studio 2005. Cheers,
Mark Brock "We're definitely not going to make a G or a PG version of this. It's not PillowfightCraft." -- Chris Metzen
if you have good internet connection then you can connect remotely as well as by using sql express and their are also so many other Sql Management tools are availbale same like sql server management studio you can use them also and there are some hand tools for sql server datase copying /backup and emailing automatically http://www.sqlbackupandftp.com/[^] http://www.download3k.com/System-Utilities/Backup-Restore/Download-SQLBackupAndFTP.html[^] while other regular options are their as well as normal backups and copy database , mirroring etc
Best Of Regards, SOFTDEV Sad like books with torn pages, sad like unfinished stories ...
-
if you have good internet connection then you can connect remotely as well as by using sql express and their are also so many other Sql Management tools are availbale same like sql server management studio you can use them also and there are some hand tools for sql server datase copying /backup and emailing automatically http://www.sqlbackupandftp.com/[^] http://www.download3k.com/System-Utilities/Backup-Restore/Download-SQLBackupAndFTP.html[^] while other regular options are their as well as normal backups and copy database , mirroring etc
Best Of Regards, SOFTDEV Sad like books with torn pages, sad like unfinished stories ...
Means he needs to expose the SQLServer browser from the firewall of the server... This would not be a good option I think. :-D
Abhishek Sur
My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB
**Don't forget to click "Good Answer" if you like to.
-
Means he needs to expose the SQLServer browser from the firewall of the server... This would not be a good option I think. :-D
Abhishek Sur
My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB
**Don't forget to click "Good Answer" if you like to.
if possible then he can add Execption depends upon cicrumstances and is one of the option if possible otherwise there copying or backup is good option and he can even export only some tables and if he can export tables into XML and then can import then it will be even another way to do it , depends upon the nature as far as my understanding is he is not using at clients he is using for his test pc at home
Best Of Regards, SOFTDEV Sad like books with torn pages, sad like unfinished stories ...