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

Posted on 2006-06-06
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
    LVL 3

    Assisted Solution

    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

    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).

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Javascript: Crash Course

    Javascript is not only emerging as the most important language to know, it's flexibility is unique. With Javascript being deployed on the web, mobile and even the desktop this is the one language that all technologists need to know.

    For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
    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 video discusses moving either the default database or any database to a new volume.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    758 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

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now