Using DreamWeaver with SQL Server 2012/2014

[Guest]

Adobe claims they have a partnership with Microsoft but I've never seen a group of products so incompatible!

Is this just a marketing lie?

Where are the details/instructions to get DreamWeaver to work with SQL Server?

[Jon Fritz]

Dreamweaver's database panels have been gone from the program for a while now.

The only way to get the functionality back is by purchasing 3rd party extensions from Webassist or DMXZone, or hand-writing the necessary code yourself.

[Nancy OShea]

For Windows servers, look at DMX Zone's extensions.   I think WebAssist is strictly PHP & MySQL.,

https://www.dmxzone.com/go/22084/dmxzone-database-connector-asp/

[pziecina]

Residentx10  wrote

Adobe claims they have a partnership with Microsoft but I've never seen a group of products so incompatible!

Is this just a marketing lie?

Adobe has partnered with Microsoft, but only in the use of the Adobe Experiance Cloud range of products, and then this is limited to the MS Azure cloud.

Whilst you could in theory use Dreamweaver, the MS Azure cloud is primarily based on the MSSQL database, which would require C# or asp.net, (it is possible to use php and pdo, but forget Dw, both past and present). The two best products to use for using the 'partnership' are -

Visual Studio Pro, (expensive) and Visual Studio Code, (free).

So it is not a 'marketing lie', but does show Adobes thinking on the use of Dreamweaver, (not really for serious professional web development anymore). Still not bad for low end static sites.

[Guest]

All these answers are useful but one more comment.

If Dreamweaver is second class now...are people really still using it? My creative cloud suite goes up in price next year but the updates I'm getting don't help me be more productive at all.

[pziecina]

Residentx10  wrote

All these answers are useful but one more comment.

If Dreamweaver is second class now...are people really still using it? My creative cloud suite goes up in price next year but the updates I'm getting don't help me be more productive at all.

I still use Dw CS6 for quick and dirty ideas, (I modified the code hints extensively myself), but unless you only intend to use bootstrap, or have/will purchase 3rd party extensions to extend or add the missing functionality, (could get very expensive) then Dw is in its current form only a collection of open source projects. Admittedly those open source projects are in one program, but for serious work you will still have to use another program to suplement Dw.

The other alternative is to use the actual open source programs, and just subscribe to the 'photographer' plan, (about $10 per month) if you require image editing software.

[Nancy OShea]

I an not one of the DW naysayers.  I use DW almost daily for site management.   The web is so complex now, I don't think you will find one tool that can do everything you need and do it well.   For this reason I also use other tools and extensions alongside DW. 

[pziecina]

https://forums.adobe.com/people/Nancy+OShea  wrote

I an not one of the DW naysayers.  I use DW almost daily for site management.   The web is so complex now, I don't think you will find one tool that can do everything you need and do it well.   For this reason I also use other tools and extensions alongside DW. 

Sorry Nancy, but if the only feature you can recommend Dw for is site managment, a feature that has virtually remained unchanged, (except for a few features being removed) since Dw MX, then at almost $300 per year that is not a 'I support Dw, and it is worth the cost' comment.

Add to that, even the site managment feature does nothing for srcset image support.

[Guest]

Who has the best website development tools today?

[osgood_]

Residentx10  wrote

Who has the best website development tools today?

A coder does.......failing that try Wordpress, or Pinegrow, if you want some dynamic front/back-end, Wappler

[Nancy OShea]

That's like asking who makes the best automobiles .

It depends on many factors.

[Guest]

Sorry, my question was pretty vague but I wanted opinions. I had hopes for Dreamweaver but with no database support I have to look for something else.

I guess if I could put a list of requirements together, it would look like this:

- Support for Dynamic websites

- Support for open and proprietary databases.

- Strong JavaScript Frameworks and ASPNET core support.

- Good management for internationalization/globalization.

I liked dreamweaver because it had some out the box templates to get going but I think I'm going to have to go back to Visual Studio but Microsoft's web solutions are so heavy.

[pziecina]

Residentx10  wrote

I liked dreamweaver because it had some out the box templates to get going but I think I'm going to have to go back to Visual Studio but Microsoft's web solutions are so heavy.

It may be worth looking at VS Code, (free) before going the VS Pro route. It does not do a lot of what VS Pro can do, (e.g. no snippets and database support is not as good) but for a free code editor it does also have lots of extensions and is easier for the casual user to learn how to use, (much of which one can transfer to VS Pro).

Edit -VS Code has very good js framework support, (especially angular.js) and has a debugger built-in.

[pziecina]

Residentx10  wrote

Who has the best website development tools today?

It all depends on what you are developing, and what you and your site(s) require.

A simple static website can be done with 'free' open source, and a couple of free extensions for them.

e.g. Both Brackets and visual studio code have free extensions for Bootstrap, git, and pre/post-processors, but no 'click to insert/use features'.

If you are developing sites with some server side requirerments, then depending on how well you know code and which server side language you are using, then VS Code, (free) or a ide that supports your server side language and database type are better suited, (many suggestions available, but for php/mysql I use phpED).

If your website is more of a browser based application then I use VS Pro. but vspro is expensive, that said if MS Edge or Azure cloud support a feature so does vs pros web dev extensions.

You will find ide's are a personal preference, and very closely linked to the work required, but for anything more than 'cut and paste' code a debugger is essential, (for both server and js code support) so look for a program that does have one built-in.