473,396 Members | 1,864 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,396 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 1458
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: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.