471,050 Members | 1,156 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,050 software developers and data experts.

Visual Studio and SQL Server - basic question

JJ
My potential shared hosting platform uses SQL server 2005. I am developing
on the Express version.

In order to make sure I am not going to cause myself any problems when I
move my ASP .net 2.0 sites (developed in Vis Studio 2005) to the host,
should I be using my developers version of SQL 2005?

If so, can I install it and keep my current instance of the SQL Server
Express edition? Or will installing the dev version upgrade that instance?

Thanks,

JJ
Aug 3 '06 #1
8 1347
JJ
Also, I assume then I'd need to also change the default profile/membership
provider from SQL Express to SQL server?
Is that easy to do?
JJ

"JJ" <ab*@xyz.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
My potential shared hosting platform uses SQL server 2005. I am developing
on the Express version.

In order to make sure I am not going to cause myself any problems when I
move my ASP .net 2.0 sites (developed in Vis Studio 2005) to the host,
should I be using my developers version of SQL 2005?

If so, can I install it and keep my current instance of the SQL Server
Express edition? Or will installing the dev version upgrade that instance?

Thanks,

JJ

Aug 3 '06 #2
"JJ" <ab*@xyz.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
My potential shared hosting platform uses SQL server 2005. I am developing
on the Express version.

In order to make sure I am not going to cause myself any problems when I
move my ASP .net 2.0 sites (developed in Vis Studio 2005) to the host,
should I be using my developers version of SQL 2005?

If so, can I install it and keep my current instance of the SQL Server
Express edition?
Slightly puzzled as to why you would want to do this... You say your host
uses SQL Server 2005, and you have a copy of SQL Server 2005...why would you
want to continue to use the Express edition...?
Aug 3 '06 #3
If you have a developers version, you are allowed to use that for
development under the terms of the msdn subscription.

You shouldn't find any problems moving to sql server 2005 at all.

Mark Rae wrote:
"JJ" <ab*@xyz.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
My potential shared hosting platform uses SQL server 2005. I am developing
on the Express version.

In order to make sure I am not going to cause myself any problems when I
move my ASP .net 2.0 sites (developed in Vis Studio 2005) to the host,
should I be using my developers version of SQL 2005?

If so, can I install it and keep my current instance of the SQL Server
Express edition?

Slightly puzzled as to why you would want to do this... You say your host
uses SQL Server 2005, and you have a copy of SQL Server 2005...why would you
want to continue to use the Express edition...?
Aug 3 '06 #4
JJ
Only because I am not totally decided on which way my development strategy
may go.
I may use mySQL for some of my large applications, and SQL server express
for others.

It is all dependant on my client s need and what hosting strategy I am going
to choose.

i.e. I want to keep my options open.

So can I keep my Express edition , or does installing the dev version it
over write it by default?

*And how easy is it to change the default profile provider from SQL Express
to SQL Server?

Thanks very much,

JJ

"Mark Rae" <ma**@markNOSPAMrae.comwrote in message
news:eu**************@TK2MSFTNGP03.phx.gbl...
"JJ" <ab*@xyz.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
>My potential shared hosting platform uses SQL server 2005. I am
developing on the Express version.

In order to make sure I am not going to cause myself any problems when I
move my ASP .net 2.0 sites (developed in Vis Studio 2005) to the host,
should I be using my developers version of SQL 2005?

If so, can I install it and keep my current instance of the SQL Server
Express edition?

Slightly puzzled as to why you would want to do this... You say your host
uses SQL Server 2005, and you have a copy of SQL Server 2005...why would
you want to continue to use the Express edition...?

Aug 3 '06 #5
You can use Express without issue, unless you need the few features not
found in Express. Make sure you have the Express Manager downloaded, as it
is a hard ride without it.

BTW, there are few features (programmatic) that are not in the Express
product.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think Outside the Box!
*************************************************
"JJ" <ab*@xyz.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
My potential shared hosting platform uses SQL server 2005. I am developing
on the Express version.

In order to make sure I am not going to cause myself any problems when I
move my ASP .net 2.0 sites (developed in Vis Studio 2005) to the host,
should I be using my developers version of SQL 2005?

If so, can I install it and keep my current instance of the SQL Server
Express edition? Or will installing the dev version upgrade that instance?

Thanks,

JJ

Aug 3 '06 #6
You can install both on the same machine. Express is simply an instance.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think Outside the Box!
*************************************************
"JJ" <ab*@xyz.comwrote in message
news:e5**************@TK2MSFTNGP04.phx.gbl...
Only because I am not totally decided on which way my development strategy
may go.
I may use mySQL for some of my large applications, and SQL server express
for others.

It is all dependant on my client s need and what hosting strategy I am
going to choose.

i.e. I want to keep my options open.

So can I keep my Express edition , or does installing the dev version it
over write it by default?

*And how easy is it to change the default profile provider from SQL
Express to SQL Server?

Thanks very much,

JJ

"Mark Rae" <ma**@markNOSPAMrae.comwrote in message
news:eu**************@TK2MSFTNGP03.phx.gbl...
>"JJ" <ab*@xyz.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
>>My potential shared hosting platform uses SQL server 2005. I am
developing on the Express version.

In order to make sure I am not going to cause myself any problems when I
move my ASP .net 2.0 sites (developed in Vis Studio 2005) to the host,
should I be using my developers version of SQL 2005?

If so, can I install it and keep my current instance of the SQL Server
Express edition?

Slightly puzzled as to why you would want to do this... You say your host
uses SQL Server 2005, and you have a copy of SQL Server 2005...why would
you want to continue to use the Express edition...?


Aug 3 '06 #7
Can you change a connection string?

Search: (local)\$Express
Replace: SomeOtherServer

Might have to change how it connects (windows auth versus SQL auth), but
that is easy.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think Outside the Box!
*************************************************
"JJ" <ab*@xyz.comwrote in message
news:uU**************@TK2MSFTNGP05.phx.gbl...
Also, I assume then I'd need to also change the default profile/membership
provider from SQL Express to SQL server?
Is that easy to do?
JJ

"JJ" <ab*@xyz.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
>My potential shared hosting platform uses SQL server 2005. I am
developing on the Express version.

In order to make sure I am not going to cause myself any problems when I
move my ASP .net 2.0 sites (developed in Vis Studio 2005) to the host,
should I be using my developers version of SQL 2005?

If so, can I install it and keep my current instance of the SQL Server
Express edition? Or will installing the dev version upgrade that
instance?

Thanks,

JJ


Aug 3 '06 #8
JJ
It wasn't existing sites I wanted to change, it was the default provider
that Visual Studio sets up when you create a new site.
How do I ensure that Visual Studio uses SQL server 2005 and not the Express
version by default for all new sites I create?

(When I go to the Admin tool, I want it to be using the SQL 2005 serve not
the express....)
??
JJ

"msnews.microsoft.com" <No************@comcast.netNoSpamMwrote in message
news:eF*************@TK2MSFTNGP05.phx.gbl...
Can you change a connection string?

Search: (local)\$Express
Replace: SomeOtherServer

Might have to change how it connects (windows auth versus SQL auth), but
that is easy.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think Outside the Box!
*************************************************
"JJ" <ab*@xyz.comwrote in message
news:uU**************@TK2MSFTNGP05.phx.gbl...
>Also, I assume then I'd need to also change the default
profile/membership provider from SQL Express to SQL server?
Is that easy to do?
JJ

"JJ" <ab*@xyz.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
>>My potential shared hosting platform uses SQL server 2005. I am
developing on the Express version.

In order to make sure I am not going to cause myself any problems when I
move my ASP .net 2.0 sites (developed in Vis Studio 2005) to the host,
should I be using my developers version of SQL 2005?

If so, can I install it and keep my current instance of the SQL Server
Express edition? Or will installing the dev version upgrade that
instance?

Thanks,

JJ



Aug 3 '06 #9

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by PkingTom | last post: by
26 posts views Thread by Bruno Jouhier [MVP] | last post: by
8 posts views Thread by WT | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.