| Author |
 Topic Search  Topic Options
|
Amateur 
Senior Member
Joined: 22 July 2004
Location: Ireland
Status: Offline
Points: 210
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 19 July 2005 at 5:28am |
Thanks very much to everyone for there advice and help.
While I understand ASP.NET2.0 is on its way it probably be another 6/8 months before release, tested fully and supported by most hosts. For that reason I think i'll stick with v1.1 for the moment.
If i pay the $50 or whatever, does it mean I can use it as back end on a web server. (Any restrictions put on me??)
|
 |
Mart
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
Post Options
Thanks(0)
Quote Reply
Posted: 19 July 2005 at 5:33am |
|
No, you can't use developer edition in production... But if you get 1.1
web hosting the chances are that it will come with a SQL Server package
included that you can use in production
|
|
dfrancis
Senior Member
Joined: 16 March 2005
Location: United States
Status: Offline
Points: 442
|
Post Options
Thanks(0)
Quote Reply
Posted: 19 July 2005 at 7:50am |
 Mart wrote:
No, you can't use developer edition in production... But if you get 1.1 web hosting the chances are that it will come with a SQL Server package included that you can use in production |
Exactly!
The dev version allows you to develop and test your application locally, but when choosing a host, make sure they offer SQL server.
The cool thing is, with the developer version you get a utility called "Enterprise Manager" that allows you to administer the database. You are "allowed" to use that utility to access the full version of SQL on your production server. For me, it was worth every penny.
|
|
Mart
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
Post Options
Thanks(0)
Quote Reply
Posted: 19 July 2005 at 8:29am |
You can get enterprise manager and query analyzer with MSDE but that method isn't exactly legal 
|
|
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
Posted: 19 July 2005 at 11:21am |
|
The developer version and MSDE also have a limit of 5 actively concurrent connections.
That's not the same as only 5 users. Depending upon the app, 5 concurrently active connections can support a lot of users.
One example I read was that the 5 concurrent connections could probably
support an hr app for a company with 1000 daily users, but would fail
when they all went to put in a time sheet at 5 PM Friday.
|
Lead me not into temptation... I know the short cut, follow me.
|
|
Amateur
Senior Member
Joined: 22 July 2004
Location: Ireland
Status: Offline
Points: 210
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 July 2005 at 4:34am |
Thanks very much lads.
So my understanding is I can develop locally a SQL Server DB using the downloaded developer edition. Then when I want to put on a webserver I use the the SQL Server that they supply.
How do I transfer my local DB to the DB on the Web Server?
Must the deleoper edition and the SQL Server suppiled by the hosting company be the same version?
Any experience of problems with connection strings after building locally and then uploading to the server?
dpyers wrote:
The developer version and MSDE also have a limit of 5 actively concurrent connections.
That's not the same as only 5 users. Depending upon the app, 5 concurrently active connections can support a lot of users.
One example I read was that the 5 concurrent connections could probably support an hr app for a company with 1000 daily users, but would fail when they all went to put in a time sheet at 5 PM Friday.
|
Slightly confused by this. Does this not mean that the supposed performance improvements by SQL Server are diluted?
|
|
Mart
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 July 2005 at 4:59am |
|
1. You can either generate a SQL Script using Enterprise Manager and
run it on your remote server, or backup and restore the database on
your remote srever, or develop on your remote server but just use the
client tools from developer edition.
2. No
3. Nope, connection strings work just fine, you just need to change the server and the initial catalog
4. That limit is only on the developer edition and MSDE - and it is
only to stop you from using it in production... 5 conncurrent
connections won't make much of a difference to you as on average my sql
server queries take 0.002 seconds (ado.net) so that means that 6 people
would need to simulateously query the database at the exact same 0.002
seconds and the 6th person would get an error - not much of a problem
if your just using it for development
|
|
Amateur
Senior Member
Joined: 22 July 2004
Location: Ireland
Status: Offline
Points: 210
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 July 2005 at 11:26am |
Cheers for that. I'll have a go with and see how it goes.
Also, is then number of times an open connection is queried or the opening of the connection hampers performance?
|
|
