473,326 Members | 2,114 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 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 1455
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: angelag | last post by:
I am currently taking a college course in Visual Basic.Net and I am a beginner. I bought Visual Studio.Net 2003 to do my homework at home. I built my first project and e-mailed it to myself at...
2
by: PkingTom | last post by:
I have read that Visual Basic 6.0 is included with Visual Studio 6.0 Professional Edition. Maybe this is a dumb question but how do I bring up the VB Editor? I wasn't sure if I installed it even...
33
by: John Timbers | last post by:
I'd like to purchase Visual C# .Net for learning purposes only since it's a lot cheaper than Visual Studio (note that I'm a very experienced C++ developer). Can someone simply clarify the basic...
17
by: Andi Plotsky | last post by:
I am not a .NET developer. I want the Developer's Edition of Visual Studio for use with my Access2000 databases. Does anyone have a clue as to where to find it - my office manager says only .NET...
26
by: Bruno Jouhier [MVP] | last post by:
I'm currently experiencing a strange phenomenon: At my Office, Visual Studio takes a very long time to compile our solution (more than 1 minute for the first project). At home, Visual Studio...
4
by: Andy | last post by:
In visual studio, I have an asp.net project. When I debug, I have to manually attach to aspnet_wp.exe. My project used to automatically attach to this process. How do I get it to automatically...
5
by: Microsoft | last post by:
Hi, I have Visual Basic .net 2003 (Standard Edition) & SQL Server 2000 Developer Edition. When trying to create a connection in the server explorer from the .net IDE I get a number of problems;...
8
by: WT | last post by:
Is it normal that Visual Studio sets the PreInit handler for a Page from the OnInit code ? No chance to fire it as OnPreInit is run befor OnInit. ??? CS
1
by: FlyingBuckner | last post by:
All right be kind, this is my first question on a forum. I need help on selecting the right software to purchase. I have a database set up using Access, 6 users. It is split into Tables and...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.