473,372 Members | 1,131 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

How to Download Remote SQL Server Database to Desktop for Development (Desktop Has MSDE & Visual Studio .Net)

TC
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
Nov 19 '05 #1
4 1884
On Fri, 4 Feb 2005 19:19:53 -0500, "TC" <ge**********@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.

Nov 19 '05 #2
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

"Jack Jackson" <ja********@pebbleridge.com> wrote in message
news:k4********************************@4ax.com...
On Fri, 4 Feb 2005 19:19:53 -0500, "TC" <ge**********@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.

Nov 19 '05 #3
oj
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/evaluat...ew/default.asp
http://support.microsoft.com/kb/268361
http://support.microsoft.com/kb/314546

--
-oj
"TC" <ge**********@yahoo.com> wrote in message
news:eh*************@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

Nov 19 '05 #4
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.

"TC" <ge**********@yahoo.com> wrote in message
news:uF**************@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" <ja********@pebbleridge.com> wrote in message
news:k4********************************@4ax.com...
On Fri, 4 Feb 2005 19:19:53 -0500, "TC" <ge**********@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 Serverdatabase 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.


Nov 19 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: bob .net | last post by:
Server exploI have recently installed Visual Studio .Net 2002 on my workstation running XP Professional. I can connect to local Access and MSDE databases successfully using ADO .Net. I can also...
2
by: Mahir Karabacak | last post by:
Hi all, I need to write an server application which will work Windows Remote Desktop Server (may be Terminal server). But the difference, insted of sending whole windows desktop messages to...
2
by: eye5600 | last post by:
1) Is there a discussion of somewhere of exactly which versions of Sql Server will work with visual Studio and C#? 2) Is it possible to use the SQL Server 2000 Desktop Engine from a different PC...
2
by: Jeff | last post by:
I have an ASP.NET web page accessing a SQL database. I've used VS to build the app and stored it in the eNPTest02 directory of my localhost on my development machine. The database is on the web. ...
5
by: Microsoft | last post by:
Hi, I have Visual Basic .net 2003 (Standard Edition) & SQL Server 2000 Developer Edition. When trying to create a connection in the server explorer from the .net IDE I get a number of problems;...
2
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This will help you judge yourself are you really worth of...
14
by: Developer | last post by:
Hello All, i have recently installed VS2005 and was trying to install SQL sever 2000. I have Win XP' SP2. But when I tried installing, it only installed client tools and not the database. Can...
8
by: vbDavidC | last post by:
I am wondering if I should use MS Access or SQL server as my database. I have a little experience programming an Access DB with VB6 (DAO/ADO). I am now starting over with VB2005 and will be doing...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.