Copy database from one remote environment to development environment
-
Hello! We are trying to refresh our development environment with data from QA server. Our QA server is located outside our network in a remote location. What is the easiest way to copy over data from QA server to our development server? Currently, following the back up database, and trying to copy over that file to restore it. any other way? Many thanks!!
-
Hello! We are trying to refresh our development environment with data from QA server. Our QA server is located outside our network in a remote location. What is the easiest way to copy over data from QA server to our development server? Currently, following the back up database, and trying to copy over that file to restore it. any other way? Many thanks!!
It has been my experience that, although painful, doing a backup and then a copy or FTP is the best solution available. I have previously been required to back up the production database and sent it via FTP to the vendor to reproduce a given problem.
-
It has been my experience that, although painful, doing a backup and then a copy or FTP is the best solution available. I have previously been required to back up the production database and sent it via FTP to the vendor to reproduce a given problem.
Yep. I agree with Tim. :thumbsup: 1) backup the database 2) FTP it to the desired location 3) restore database You may want to perform a data compression on the backup, but sometimes it doesn't really compress.
-
Yep. I agree with Tim. :thumbsup: 1) backup the database 2) FTP it to the desired location 3) restore database You may want to perform a data compression on the backup, but sometimes it doesn't really compress.
-
It has been my experience that, although painful, doing a backup and then a copy or FTP is the best solution available. I have previously been required to back up the production database and sent it via FTP to the vendor to reproduce a given problem.
-
7-zip usually seems to produce smaller results than regular zip files. On one server, it compressed a 1.3Gb backup file to 55Mb, which took the nightly FTP transfer down from 7 hours to around 15 minutes.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
7-zip usually seems to produce smaller results than regular zip files. On one server, it compressed a 1.3Gb backup file to 55Mb, which took the nightly FTP transfer down from 7 hours to around 15 minutes.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
Yes, once zipped - the file size from 2 GB has come down to 850MB. I am trying to do a copy of the file from remote server, literal right click copy, and right click paste on to my laptop. I keep losing the connection. If we use a FTP tool, would this be the same issue, of losing the file transfer connection? Thanks for all the ideas and suggestions.
-
Yes, once zipped - the file size from 2 GB has come down to 850MB. I am trying to do a copy of the file from remote server, literal right click copy, and right click paste on to my laptop. I keep losing the connection. If we use a FTP tool, would this be the same issue, of losing the file transfer connection? Thanks for all the ideas and suggestions.
FTP tends to be more robust than copy+paste in Explorer. However, if you have underlying network problems, you'll still have problems with FTP transfers. I'd be inclined to give 7zip[^] a go - the maximum compression settings will take a bit longer, but they should be able to get the file size down a lot further.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
Yes, once zipped - the file size from 2 GB has come down to 850MB. I am trying to do a copy of the file from remote server, literal right click copy, and right click paste on to my laptop. I keep losing the connection. If we use a FTP tool, would this be the same issue, of losing the file transfer connection? Thanks for all the ideas and suggestions.
-
Hello! We are trying to refresh our development environment with data from QA server. Our QA server is located outside our network in a remote location. What is the easiest way to copy over data from QA server to our development server? Currently, following the back up database, and trying to copy over that file to restore it. any other way? Many thanks!!
great question. i've been having similar problems myself. addictive medications medication mistakes prescription addiction what to do for an overdose prescription narcotic abuse effects of addiction addiction signs and symptoms signs and symptoms of overdose what are symptoms of overdose what are the signs of overdose prescription drug abuse what are the side effects of painkillers
