From MSDE to SQL Server 2005 Express Ed...

David Lozzi

Howdy,

My company is setting up a new dedicated hosting server and we're debating
using the new SQL 2005 verse the MSDE. I'm not familiar with the new
version, so I have one big question:: Outside of the connection string, will
any syntax in my existing ASP.NET script/stored procs have to change to
support SQL 2005? Is the migration process painless?

I've searched MSDN but really can't find what I'm looking for.

Thanks,

--
David Lozzi
Web Applications Developer
dlozzi@(remove-this)delphi-ts.com

Nov 21 '05 #1

Subscribe Reply

981

Bruce Barker

should be painless.

the most common issue is some quirk in query optimization, but if you were
use msde, this should not be a case. the other is default security changes.

-- bruce (sqlwork.com)

"David Lozzi" <Da********@nos pam.nospam> wrote in message
news:Ol******** *****@TK2MSFTNG P15.phx.gbl...

Howdy,

My company is setting up a new dedicated hosting server and we're debating
using the new SQL 2005 verse the MSDE. I'm not familiar with the new
version, so I have one big question:: Outside of the connection string,
will any syntax in my existing ASP.NET script/stored procs have to change
to support SQL 2005? Is the migration process painless?

I've searched MSDN but really can't find what I'm looking for.

Thanks,

--
David Lozzi
Web Applications Developer
dlozzi@(remove-this)delphi-ts.com

Nov 21 '05 #2

Michael Cheng [MSFT]

Hi David,

Welcome to use MSDN Managed Newsgroup!

I have also noticed you post a duplicated post in
microsoft.publi c.sqlserver.pro gramming. To keep the integrity of newsgroup,
I will reply here for your question and follow-up question.

Generally speaking, it would be painless when you are using SQL Server 2005
Express.

However, I would like to inform you the new security feature of SQL Server
2005 - User-Schema Separation. A schema is a collection of database
entities that form a single namespace in SQL Server 2005. A namespace is a
set in which every element has a unique name.

For example, to avoid name collisions, no two tables in the same schema can
have the same name. Two tables can have the same name only if they are in
separate schemas. For more information, check the topic below

User-Schema Separation
http://msdn2.microsoft.com/en-us/library/ms190387.aspx

For example, if you specifying the object accounting.ap.u ser.reconciliat ion
in the application, you may need to change it as
accounting.ap.s chema.reconcili ation accordingly.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=============== =============== =============== ========
This posting is provided "AS IS" with no warranties, and confers no rights.

Nov 23 '05 #3

Similar topics

3799

Can't install MSDE

by: Bruno Panetta | last post by:

I have tried to install MSDE 2000, first the normal version, then the one for developers using Visual Studio .NET. Each time the installation appears to complete, but there is no shortcut to start the program and it's not in the Start/Programs menu. However, if I look for it in "Add and Remove Programs" it's there. The directory C:\Program Files\Microsoft SQL Server\MSSQL\Binn includes some exe files and I have tried to start them,...

Microsoft SQL Server

2995

Performance of MSDE over VPN

by: Morning DJ | last post by:

I have read many posts which say putting a back end mdb on a wan will make for some sorry performance for those not local to the machine with the mdb. Is the same true if the back end is an MSDE database? If I could find an ISP that would be willing to run a VPN through to a computer that had MSDE installed and would let me put a database on that computer, would a local version of Access be able to access the database on that computer...

Microsoft Access / VBA

1164

Please help: steps to go from SQL Express and SQL 2005 Production

by: va | last post by:

Not sure if I should post this here or SQL so here goes... I really need some advice regarding how to handle ASP.NET 2.0 development and SQL MSDE and 2005 Server. Maybe I am just making this more difficult then it is - please let me know. Background

ASP.NET

4225

MSDE 2000 Connection String

by: hfk0 | last post by:

Hi, I have a simple asp.net application running ok on my WinXP development server with SQL Server Express 2005 installed locally. After moving to the live server (Win 2000 server with MSDE 2000 installed locally), it's giving me the 'SQL Network Interface Error (error 25): connection string is not valid'. So far, i've tried using the following connection string in my web.config file:

ASP.NET

2103

Move from SBS2003 MSDE to MS SQL 2005 Express

by: Brian Smither | last post by:

I have SBS2003-SP1 (with MSDE) installed. I have read several "How-To's" on upgrading MSDE to 2K5Express, but none have directly answered the SBS2003/MSDE install scenario: is MSDE a "module" of Sharepoint/SBS- Monitoring, or is it an MSI install, brought in with the OS install? The How-To's state that if you can see it in Add/Remove programs, then it is an MSI install and 2K5Express will see it and upgrade it and the databases as...

Microsoft SQL Server

2256

c# and MSDE

by: Jason | last post by:

If I've got simple Access DB, and I've got a front end with a with a datagrid and use SQL SERver 2005 Expression edition to create the connections, develop the app then I give the DB and the front end application to end users, do they need to have MSDE installed on there PC?

C# / C Sharp

6240

SQL Slow from MSDE 2000 to SQL Express

by: HC | last post by:

I posted this in one of the VB forums but I'm starting to think it might be more appropriate to have it here, since it really seems to be a SQL server (MSDE/Express 2005) problem: Hey, all, I have a problem with queries against a SQL server instance that I just found and is causing me fits. I hope someone can point me in the right direction, please. TIA. Basically, I got a Vista OS machine to test my VB6 app on it as some

Microsoft SQL Server

1306

Possible to run MSDE (2000) and 2005 Express at the same time

by: bergy | last post by:

Just wondering if this is possible, I'm coding this application that will run on a network with a SQL Server 2000, however each workstation (notebook computers in this case) will need to copy some of that data locally to a SQL 2005 Express instance. On the computer I'm developing on I'd like to have an instance of both MSDE and SQL 2005 Express running so I can replicate the network as close to possible while writing code. Alternatively I...

Microsoft SQL Server

1322

Msde Boostraper =>>> what's new with SQL server 2005

by: sebastien1101 | last post by:

I have to produce a new application using now Visual Studio 2005 & Sql server 2005 express Before with VS2003 i use the msde Boostraper to deploy my database.... What i have to do with sql server 2005 express ?

Visual Basic .NET

2072

SQL Express and MSDE

by: Tony Johansson | last post by:

Hello! Visual Studio 2005 includes a copy of SQL Express which is a lightweight desktop engine version of SQL Server 2005. Now to my question what is MSDE(Desktop Engine) is that the same as SQL Express ? //Tony

C# / C Sharp

8674

What is ONU?

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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9157

Problem With Comparison Operator <=> in G++

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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8893

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8861

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7723

AI Job Threat for Devs

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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6518

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5860

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4366

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3045

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp