Local SQL Express for ASP.NET/Sharepoint Development?

Question

In your development environment, do you install a local SQL express or a dedicated SQL server? What are the pro/con's of these two options?

From my own experience so far:

Local installation slows down the own development workstation due to resource consumption
Local installation is easier to debug/manage
Dedicated installation eases central administration (backup, etc)

What are your personal experiences and suggestions?

CAD bloke · Accepted Answer · 2009-02-10 09:44:04Z

1

I think it really depends on how busy you expect the app to be & any cost restrictions (number of boxes, rack space etc.). If it's a low traffic inter / intranet server I'd be inclined put them on the same box. If the SQL was a small part of a busy web server, separate them. If you encapsualte them well enough then the deployment differences are a matter of configuration, rather than re-coding. ie. Code for both eventualities.

SQL Express can only use 1GB of RAM & a 4GB database - it will get only-so busy.

answered Feb 10, 2009 at 9:44

CAD bloke

8,8949 gold badges71 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

AJM · Accepted Answer · 2009-02-10 10:11:47Z

1

Local is useful when working on a laptop/from home where don't have access to a network.

Also useful when want to work on isolation from other developers and not worry about someone elses work on the same database / other activities on the server slowing you down.

I work on the server but use a local instance for the above cases

answered Feb 10, 2009 at 10:11

AJM

32.6k51 gold badges161 silver badges249 bronze badges

Collectives™ on Stack Overflow

Local SQL Express for ASP.NET/Sharepoint Development?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related