467,188 Members | 1,416 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,188 developers. It's quick & easy.

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
  • viewed: 1235
Share:
8 Replies
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

1 post views Thread by angelag@comcast.net | last post: by
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
By using this site, you agree to our Privacy Policy and Terms of Use.