Mixing SQL Server and SQL Server Express

VWD 2008 Express.  Visual Basic.

I have some questions:

1.  If I create a web site that uses a local database (stored in a directory in my web site's root directory) handled by SQL Server 2008 Express, what happens when I move the site from VWD to my server?  My server has SQL Server 2005 Standard running on it.  Will my site run even if SQL Server 2008 Express is not installed on the server?  Do I need to install SQL Server 2008 Express on my server?

2.  Can my Windows 2003 Server run both SQL Server 2005 Standard and SQL Server 2008 Express?

3.  What advantages/disadvantages are there in using SQL Server 2008 Express rather than SQL Server 2005 Standard to manage my site's database.  Can I create views, functions, and routines in SQL Server 2008 Express while in the VWD environment?

Thanks for the help.

 


Dr. Douglas Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org
0
Chaplain
8/14/2008 5:18:11 PM
asp.net.getting-started 91979 articles. 4 followers. Follow

2 Replies
883 Views

Similar Articles

[PageSpeed] 5
Get it on Google Play
Get it on Apple App Store

Chaplain Doug:
1.  If I create a web site that uses a local database (stored in a directory in my web site's root directory) handled by SQL Server 2008 Express, what happens when I move the site from VWD to my server?  My server has SQL Server 2005 Standard running on it.  Will my site run even if SQL Server 2008 Express is not installed on the server?  Do I need to install SQL Server 2008 Express on my server?
-- You can either migrate to sql server standard or if you still intend to use express.. you will need to install the express edition on the server

http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx

Chaplain Doug:
2.  Can my Windows 2003 Server run both SQL Server 2005 Standard and SQL Server 2008 Express?
- as far as I know yes,, but given a choice I would stick to just having standard edition

Chaplain Doug:
What advantages/disadvantages are there in using SQL Server 2008 Express rather than SQL Server 2005 Standard to manage my site's database.  Can I create views, functions, and routines in SQL Server 2008 Express while in the VWD environment?
-- You can have views function etc in both. See here for a detailed comparison

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

 


Jeev
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If you get the answer to your question, please mark it as the answer.
0
Jeev
8/14/2008 5:26:12 PM
Thank you for the prompt reply. I got it last week, but am just delinquent in thanking you. 

 


Dr. Douglas Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org
0
Chaplain
8/18/2008 4:11:23 PM
Reply:

Similar Artilces:

SQL Server 2005 Installation problems with SQL Server Express & SQL Server 2000
Hi Guys, I have had SQL Server Express and Sql Server Management Studio Express installed on my machine for some time and recently tried to install a trial of SQL Server 2005 as well.  (Yes, I'm migrating from Visual Studio Express to Visual Studio Professional, just as in tended!) Everything went fine except that nothing seemed to be installed.  I searched in all the obvious places - both on the Start/Programs menu and on the hard-drive: nothing. A check under Add/Remove Programs showed that Sql Server 2005 Express was installed, but called SQL Server 2005. So after a number o...

Converting MDF files (SQL Server Express) to SQL Server 2005 WITHOUT having to buy SQL Server 2005 (I have Express). Personal WebSite Starter Kit
Hi (and HELP!),   I downloaded the Personal WebSite Starter Kit and got it working no problem on my local machine.  But I've had nothing but frustration trying to get it up and running on a webhosting site.  I picked hostmysite.com which uses SQL Server 2005.  I was under the impression that it wouldn't be that big a deal to convert the .MDF files that Sql Server Express uses to a SQL Server 2005 database.  I tried using SQL Server Management Studio Express.  I was able to "see" my remote database on hostmysite.com, but I was not able to import the .mdf file...

Converting MDF files (SQL Server Express) to SQL Server 2005 WITHOUT having to buy SQL Server 2005 (I have Express). Personal WebSite Starter Kit
Hi,Basically i built a webpage with Login and it's working well from my local machine.Right now, i'm using Database Publishing Wizard. the problem is how do i convert.MDF files to .SQL 2005 to get my database publish in the internet? thanks  Place your .MDF file in the App_Data directory, change the connection string accordingly and then publish your web site. ----------------------------------------------------------Please click Mark As Answer if this helped in solving your problem.  Please click "Mark As Answer" if this hepled in solving your problem. ...

Converting MDF files (SQL Server Express) to SQL Server 2005 WITHOUT having to buy SQL Server 2005 (I have Express). Personal WebSite Starter Kit
Hi (and HELP!),   I downloaded the Personal WebSite Starter Kit and got it working no problem on my local machine.  But I've had nothing but frustration trying to get it up and running on a webhosting site.  I picked hostmysite.com which uses SQL Server 2005.  I was under the impression that it wouldn't be that big a deal to convert the .MDF files that Sql Server Express uses to a SQL Server 2005 database.  I tried using SQL Server Management Studio Express.  I was able to "see" my remote database on hostmysite.com, but I was not able to import the .mdf files ...

sql server and sql server express
ok i am puzzled right now....i have a web application connecting to a sql server database....i uninstalled sql server express and installed sql server 2005 full version...i changed the connection string in my application to be Data Source=SKYBANDR62;Initial Catalog=aspnetdb;Integrated Security=True and through the explorer bar i can access my database freely but when i run my application i get this error Server Error in '/' Application. -------------------------------------------------------------------------------- An error has occurred while establishing a...

Deploy Sql Server Express DB to Sql Server Express
I have developed by webite with Visual Studio 2005 and sql server express. I'm trying to deploy my website to a VPS with sql server express running on it I ftp'd the App_Data folder to the remote via the 'copy web site' Everything seemed okay until I started trying to run more complex database operations using stored procedures and transactions. It appears that the schema is messed up because when defining the parameters for a stored procedure, upon ExecuteNonQuery I get the error that I've assigned too many parameters which I have not (since it runs fine on...

sql server and sql server express conflict
hey all please help me ....i have been working on this issue for 2 days i created a web application with a automatically generated security database and added tables to it and it was working fine...i had to a linked server the linked server cannot be added from sql server express so i installed the full version...it was working fine until suddenly i got this error "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed" so i searched and searched then i found out that i cannot have the two ver...

SQL Server Express and SQL Server 2005
can any one tell me what the main differences are in the two editions? also can you use and express 2005 edition database on sql 2005? if not how would you do that? Tuppers Look here for a detailed comparison between the two.Yes, you can use Express databases on SQL Server 2005. Just attach it to an instance of SQL Server 2005.Is this enough information?DonDon Kiely, MCP, MCSDIn the Last Frontier, Interior AlaskaPlease post questions and replies to the forum! And remember to MARK AS ANSWER when someone definitively answers a question or resolves a problem! cheers i was told by my host t...

SQL Server Express
I'm developing applications with VWD Beta1 and SQLServer Express, and when its possible I'll want to publish it on the INet. I'll probably publish it in a server with SQLServer (without Express), and I want to know if I will have to change something in my code for this change. Thanks!!subgurim.net: blog de ASP.NET 2.0 con C# en castellanoes-asp.net: el portal de ASP.NET en castellano If you don't use any specific SQl 2005 Features, you should probably not need to change your code (Maybe only the connection string so it will target the other Sql Server)./Fredrik Normén - fredrikn @ tw...

SQL SERVER EXPRESS versus SQL SERVER
Would anyone really use ASPNET2 Membership Services with its built in Sql Server Express database for a major, heavy traffic website? How well would sql server express handle 1 million members? Can anyone point me to an article comparing performance of full blow Sql Server with (watered down?) Sql Server Express? Seems to me you already know the answer to this question in the way you ask the question.  SQL Server express is just for normal web applications for learning/teaching and small time deployment.  Obviously by logic heavy traffic ( esp in the 1 million range even in t...

SQL Server Express file to Sql Server
I would like to copy the schema and data of a sql server express database file to a SQL Server Database. How can this be done and what steps would I need to take?   Thanks for any helpTinyPond TinyPond:I would like to copy the schema and data of a sql server express database file to a SQL Server Database. How can this be done and what steps would I need to take? If you have Express Management Studio, you back backup your database, and them import it to SQL Server (or attach and reattach).Justs open SQL Server Express Management Studio, connect to your Express instanc...

How to connect to my sql server express,also Pubs and northwind for sql server express
1, I have installed VWD express,sql server 2005 express.I also install management studio and adventureswork db.In the management studio I can able to connect and view adventurework db.But I can't manage to make a connection string to my db server when connecting to management studio server name is "KAMRANSHAHID\SQLEXPRESS".I wants a connection string with respect to this server.2,Is there new database for pubs and northwind for sql server 2005.Or they are of old sql server 2000.I have installed sample databases but can't find script for pubs and northwind nor it install automatically.I wan't...

SQL Server 2000 and SQL Server 2005 in the same server
Can enyone please send me a link to a white paper explaining how to run both SQL Server 2000 and 2005 in the same machine?Thanks. I don't know about the white paper but I had both running on my machine for a while by making the SQL 2000 a named instance. So for SQL 2005 connection strings my server name was (local) while for SQL 200 using the named instance it was (local)\joesql where joesql was the instance nameHope it helps,Joe http://www.joeaudette.comhttp://www.mojoportal.com...

VWD, Sql Server 2005, and SQL Server Express
I need to have VWD with SQL Express working on the same machine with the evaluation copy of SQL Server 2005. This is because only SQL Server 2005 has SQL Server Management Studio, which I need to a) move a snapshot of my legacy data from SQL Server 2000 to SQL Server Express during development, and then b) move the SQL Express .mdf to either a SQL 2000 or 2005 hosted instance. There are currently two problems. The first is with SQL Server 2005. When starting up SQL Server Management Studio, or running a query, a message box with the following error appears: "Cannot crea...

Web resources about - Mixing SQL Server and SQL Server Express - asp.net.getting-started

The Indian Express: Latest News, Breaking News Live, Current Headlines, India News Online
Indian Express covers latest news from India, all exclusive current headlines and India news live, including latest breaking news on business, ...

Local news, sports, obituaries, classifieds and more - Tallmadge Express
NEWARK, N.J. (AP) Gov. Chris Christie, who once famously called himself "the healthiest fat...

Sussex Express
Search continues for boy swept out to sea at... The search has continued today (Monday October 28) for the 14-year-old local boy who was swept ...

PCI Express - Wikipedia, the free encyclopedia
... standard support hardware I/O virtualization. The PCIe electrical interface is also used in a variety of other standards, most notably ExpressCard ...

Fans, teammates express shock, sadness over death of rugby legend Jonah Lomu - CTV News
Jonah Lomu's huge impact on the game of rugby and his fame, which spilled beyond the sport's traditional borders, was reflected in the breadth ...

Apple Pay goes live in Australia with American Express, loyalty card support coming ‘soon’
... earlier this week in Canada , following the late 2014 launch in the United States. Currently, the service is limited solely to American Express ...

The best place for creatives to express themselves
... with a few fun jokes. But then he passionately went into why Tumblr exists. David wanted to build the very best place for creatives to express ...

San Francisco Sues American Express, Alleging Illegal Restraints On Merchants
Earlier this year, a federal court ruled that American Express violated antitrust laws — resulting in higher costs for consumers — by forbidding ...

American Express bringing Apple Pay to Canada
American Express has reportedly confirmed that AmEx users in Canada will be able to use Apple Pay this week, beginning Tuesday, November 17. ...

Kenneth Branagh Will Direct And Star In Fox’s ‘Murder On The Orient Express’
... forth a new adaptation of Agatha Christie’s definitive mystery novel, tapping Kenneth Branagh to direct and star in Murder On The Orient Express ...

Resources last updated: 11/25/2015 6:39:51 PM