Remote SQL data backup
-
Hi, I'm using SQL Management Studio Express to manage my databases that are on my hosted server. The problem with this is that there is no easy way to get a backup of the data as the Express edition doesn't support DTS. The only way I can do it is to create a support ticket with my hosting company and getting them to do it manually. Now, my first question is: Does anybody know of some software (free if possible) that will export sql data on a remote machine to a file on a local machine? I couldn't find one when googling, so I started writing my own. I've got it exporting to xml just fine, currently working on the import. Would anyone be interested in this little tool? I'm thinking about starting up an open source project for it if there isn't already one around. Not sure how to go about it though? Comments? Andy
-
Hi, I'm using SQL Management Studio Express to manage my databases that are on my hosted server. The problem with this is that there is no easy way to get a backup of the data as the Express edition doesn't support DTS. The only way I can do it is to create a support ticket with my hosting company and getting them to do it manually. Now, my first question is: Does anybody know of some software (free if possible) that will export sql data on a remote machine to a file on a local machine? I couldn't find one when googling, so I started writing my own. I've got it exporting to xml just fine, currently working on the import. Would anyone be interested in this little tool? I'm thinking about starting up an open source project for it if there isn't already one around. Not sure how to go about it though? Comments? Andy
I don't know of a tool, but if you're writing one that would be brilliant.
cheers, Chris Maunder
CodeProject.com : C++ MVP
-
Hi, I'm using SQL Management Studio Express to manage my databases that are on my hosted server. The problem with this is that there is no easy way to get a backup of the data as the Express edition doesn't support DTS. The only way I can do it is to create a support ticket with my hosting company and getting them to do it manually. Now, my first question is: Does anybody know of some software (free if possible) that will export sql data on a remote machine to a file on a local machine? I couldn't find one when googling, so I started writing my own. I've got it exporting to xml just fine, currently working on the import. Would anyone be interested in this little tool? I'm thinking about starting up an open source project for it if there isn't already one around. Not sure how to go about it though? Comments? Andy
-
Hi, I'm using SQL Management Studio Express to manage my databases that are on my hosted server. The problem with this is that there is no easy way to get a backup of the data as the Express edition doesn't support DTS. The only way I can do it is to create a support ticket with my hosting company and getting them to do it manually. Now, my first question is: Does anybody know of some software (free if possible) that will export sql data on a remote machine to a file on a local machine? I couldn't find one when googling, so I started writing my own. I've got it exporting to xml just fine, currently working on the import. Would anyone be interested in this little tool? I'm thinking about starting up an open source project for it if there isn't already one around. Not sure how to go about it though? Comments? Andy
'--8<------------------------ Ex Datis: Duncan Jones Merrion Computing Ltd
-
Hi, I'm using SQL Management Studio Express to manage my databases that are on my hosted server. The problem with this is that there is no easy way to get a backup of the data as the Express edition doesn't support DTS. The only way I can do it is to create a support ticket with my hosting company and getting them to do it manually. Now, my first question is: Does anybody know of some software (free if possible) that will export sql data on a remote machine to a file on a local machine? I couldn't find one when googling, so I started writing my own. I've got it exporting to xml just fine, currently working on the import. Would anyone be interested in this little tool? I'm thinking about starting up an open source project for it if there isn't already one around. Not sure how to go about it though? Comments? Andy
BigAndy wrote:
I couldn't find one when googling, so I started writing my own. I've got it exporting to xml just fine, currently working on the import. Would anyone be interested in this little tool? I'm thinking about starting up an open source project for it if there isn't already one around. Not sure how to go about it though?
It would be great, I'm looking forward to it. :)
________________________________________________ Tozzi is right: Gaia is getting rid of us. Personal Blog [ITA] - Tech Blog [ENG] Developing ScrewTurn Wiki 1.0 RC, now with AJAX Preview.
-
Hi, I'm using SQL Management Studio Express to manage my databases that are on my hosted server. The problem with this is that there is no easy way to get a backup of the data as the Express edition doesn't support DTS. The only way I can do it is to create a support ticket with my hosting company and getting them to do it manually. Now, my first question is: Does anybody know of some software (free if possible) that will export sql data on a remote machine to a file on a local machine? I couldn't find one when googling, so I started writing my own. I've got it exporting to xml just fine, currently working on the import. Would anyone be interested in this little tool? I'm thinking about starting up an open source project for it if there isn't already one around. Not sure how to go about it though? Comments? Andy
-
Hi, I'm using SQL Management Studio Express to manage my databases that are on my hosted server. The problem with this is that there is no easy way to get a backup of the data as the Express edition doesn't support DTS. The only way I can do it is to create a support ticket with my hosting company and getting them to do it manually. Now, my first question is: Does anybody know of some software (free if possible) that will export sql data on a remote machine to a file on a local machine? I couldn't find one when googling, so I started writing my own. I've got it exporting to xml just fine, currently working on the import. Would anyone be interested in this little tool? I'm thinking about starting up an open source project for it if there isn't already one around. Not sure how to go about it though? Comments? Andy
I use a combination of an osql backup script and Cobian Backup http://www.educ.umu.se/~cobian/cobianbackup.htm[^] to backup my SQL database files to my external drive. I'll admit that I dont use a remote backup myself, however Cobian does support backups to remote systems via FTP (including 128 or 256 bit encryption, zipping, or SSL support if that is important to you. It also supports backup of large files (ie over 2 GB) over FTP). Cobian is free/donation software. Cobian allows me to execute the osql batch file as pre-processing for the backup process. Once the database backup file is created by the script, then Cobian performs the backup of the SQL database backup file (backing up the original SQL data file has locking restrictions). I suppose you could also use SQL Agent (instead of an osql script) to create a scheduled backup of the SQL database if that is more to your need. For my needs the script works fine. Regards, David -- modified at 12:12 Wednesday 30th August, 2006
-
Hi, I'm using SQL Management Studio Express to manage my databases that are on my hosted server. The problem with this is that there is no easy way to get a backup of the data as the Express edition doesn't support DTS. The only way I can do it is to create a support ticket with my hosting company and getting them to do it manually. Now, my first question is: Does anybody know of some software (free if possible) that will export sql data on a remote machine to a file on a local machine? I couldn't find one when googling, so I started writing my own. I've got it exporting to xml just fine, currently working on the import. Would anyone be interested in this little tool? I'm thinking about starting up an open source project for it if there isn't already one around. Not sure how to go about it though? Comments? Andy
Do you need something web-based? I posted a new article earlier: Web SQL Utility[^]. One feature is that it will generate INSERT queries of your existing data... so you don't need an import facility, you just execute the queries on the target empty table(s).
"Nothing ever changes by staying the same." - David Brent (BBC's The Office)
~ ScrollingGrid: A cross-browser freeze-header control for the ASP.NET DataGrid
-
Hi, I'm using SQL Management Studio Express to manage my databases that are on my hosted server. The problem with this is that there is no easy way to get a backup of the data as the Express edition doesn't support DTS. The only way I can do it is to create a support ticket with my hosting company and getting them to do it manually. Now, my first question is: Does anybody know of some software (free if possible) that will export sql data on a remote machine to a file on a local machine? I couldn't find one when googling, so I started writing my own. I've got it exporting to xml just fine, currently working on the import. Would anyone be interested in this little tool? I'm thinking about starting up an open source project for it if there isn't already one around. Not sure how to go about it though? Comments? Andy
You might be able to use this if your host has ASP.NET 2 installed. MSDN documentation: http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy.aspx[^]
"Nothing ever changes by staying the same." - David Brent (BBC's The Office)
~ ScrollingGrid: A cross-browser freeze-header control for the ASP.NET DataGrid