[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Developing in Dreamweaver for a remote ASP site which has a remote SQL server database

Posted on 2006-06-06
Medium Priority
Last Modified: 2010-04-25

I'd like some advice on setting up my Dreamweaver environment on my local pc running XP. I have sql Ent mgr on my machine and a small network with a sql server on.

I'm working on a remote site which has a remote sql dsn connection.

Should I set up an identical database on my pc or my local server or just use the remote db or a combination of these?

The remote site isn't in production at this stage
Question by:chiii0ut

Assisted Solution

Onyx23 earned 150 total points
ID: 16843224
You COULD use remote server for the entire site infrastructure, even for SQL Server. If you can create a virtual dir on the server so that you'll have an independeneft testing platform (testing server). The only reason I can see for having an identical (local) Dbase is for backup.

Downside with using a local server is that the possibility of using the “LocalSqlServer” connection string name – which will feel weird when you deploy yourdatabase on another machine.  If (for some reason) you need to change the existing connection  name with another connection string name, you would have to add a completely new connection-string, and then pointing the existing providers to use the new connection-string name in place of the default LocalSqlServer one which may be a hassle.

Just a thought.
LVL 23

Accepted Solution

Saqib Khan earned 750 total points
ID: 16858481
its always a good idea to have Stagiing (test) Server.

You must have have a Local Web Server and Local SQL Server running for your test work. when you done working, upload those changes to live server.
keep your connection string file seperate and try not to upload it, because the one on local server will always talk to local site.

this way you will have a back up of Live Site PLUS you will be working must faster on local version(avoiding Ftp and Fast local access).

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
This article is very specific and is only intended to help if you are installing Dreamweaver 8 in a Windows 7 environment with Office 2007 installed.   I'm not sure why Microsoft tends to release OS' that should not be released but they do.  Windows…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses
Course of the Month19 days, 20 hours left to enroll

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question