|
|
You're in the
sql server msde
group:How to Download Remote SQL Server Database to Desktop for Development (Desktop Has MSDE & Visual Studio .Net)
sql server msde:
[quoted text, click to view] wrote: >Hello All, > >I apology for posting to many groups but I wasn't sure which group would be >best targeted with my question. > >I have inherited an ASP.Net application that requires some maintenance & bug >fixes. I have been asked to also download a copy of the remote SQL Server >database that it uses on the background for potential maintenance and >changes as well. > >The application runs fine from my development environment on my desktop. > >Does anybody have any experience, advice or answers regarding a method(s) to >download & use a remotely stored SQL Server database? > If I understand what you want: Create a backup of the database Transfer the backup to your computer Install SQL Server on your computer Create a database and restore the backup.
Hello All,
I apology for posting to many groups but I wasn't sure which group would be best targeted with my question. I have inherited an ASP.Net application that requires some maintenance & bug fixes. I have been asked to also download a copy of the remote SQL Server database that it uses on the background for potential maintenance and changes as well. The application runs fine from my development environment on my desktop. Does anybody have any experience, advice or answers regarding a method(s) to download & use a remotely stored SQL Server database? Thanks & Regards, TC
Hey Jack,
The backup is already created remotely by someone else. Basically, I need to transfer a copy to my computer. I was also wondering if I can work on the database using the MSDE that installs with Visual Studio? When completed with any changes, yes, I would like to be able to then upload it up to the remote server. Thanks & Regards, TC [quoted text, click to view] "Jack Jackson" <jacknospam@pebbleridge.com> wrote in message news:k45801lto4rojchem1unu4t6f5o4422vqq@4ax.com... > On Fri, 4 Feb 2005 19:19:53 -0500, "TC" <getmyemails2@yahoo.com> > wrote: > >>Hello All, >> >>I apology for posting to many groups but I wasn't sure which group would >>be >>best targeted with my question. >> >>I have inherited an ASP.Net application that requires some maintenance & >>bug >>fixes. I have been asked to also download a copy of the remote SQL Server >>database that it uses on the background for potential maintenance and >>changes as well. >> >>The application runs fine from my development environment on my desktop. >> >>Does anybody have any experience, advice or answers regarding a method(s) >>to >>download & use a remotely stored SQL Server database? >> > > If I understand what you want: > > Create a backup of the database > Transfer the backup to your computer > Install SQL Server on your computer > Create a database and restore the backup. >
You should be able to use the backup copy of the database. Be aware that
there are limitations depending on the source and target editions. http://www.microsoft.com/sql/evaluation/overview/default.asp http://support.microsoft.com/kb/268361 http://support.microsoft.com/kb/314546 -- -oj [quoted text, click to view] "TC" <getmyemails2@yahoo.com> wrote in message news:eha71hxCFHA.228@tk2msftngp13.phx.gbl... > Hello All, > > I apology for posting to many groups but I wasn't sure which group would > be best targeted with my question. > > I have inherited an ASP.Net application that requires some maintenance & > bug fixes. I have been asked to also download a copy of the remote SQL > Server database that it uses on the background for potential maintenance > and changes as well. > > The application runs fine from my development environment on my desktop. > > Does anybody have any experience, advice or answers regarding a method(s) > to download & use a remotely stored SQL Server database? > > Thanks & Regards, > > TC >
To restore a copy of the production database to your local development
server, just ask the network admin to set you up with a read-only login for the folder where the database backups are maintained. You can then retore the a full backup file to your server. Transferring logins and permissions is a pain in the ass (it sometimes requires excuting system SPs manually for each login), so you will probably want to do this type of full restore only once. Once done, generate scripts for any SPs, table changes, etc. that you make in development, and deploy only the scripts to production (remember to include the permissions option) when generating the scripts. I would not reccoment restoring the database from development back to production. This would present some very nasty logistical problems when trying to maintain data, permissions and server uptime. After all, you can spend half a day debuging your development database, but having the production database offline for that much time could be a disaster. [quoted text, click to view] "TC" <getmyemails2@yahoo.com> wrote in message news:uFSrryxCFHA.3812@TK2MSFTNGP15.phx.gbl... > Hey Jack, > > The backup is already created remotely by someone else. > > Basically, I need to transfer a copy to my computer. I was also wondering > if I can work on the database using the MSDE that installs with Visual > Studio? > > When completed with any changes, yes, I would like to be able to then upload > it up to the remote server. > > Thanks & Regards, > > TC > > > > "Jack Jackson" <jacknospam@pebbleridge.com> wrote in message > news:k45801lto4rojchem1unu4t6f5o4422vqq@4ax.com... > > On Fri, 4 Feb 2005 19:19:53 -0500, "TC" <getmyemails2@yahoo.com> > > wrote: > > > >>Hello All, > >> > >>I apology for posting to many groups but I wasn't sure which group would > >>be > >>best targeted with my question. > >> > >>I have inherited an ASP.Net application that requires some maintenance & > >>bug > >>fixes. I have been asked to also download a copy of the remote SQL Server > >>database that it uses on the background for potential maintenance and > >>changes as well. > >> > >>The application runs fine from my development environment on my desktop. > >> > >>Does anybody have any experience, advice or answers regarding a method(s) > >>to > >>download & use a remotely stored SQL Server database? > >> > > > > If I understand what you want: > > > > Create a backup of the database > > Transfer the backup to your computer > > Install SQL Server on your computer > > Create a database and restore the backup. > > > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |