Re: SQLExpress

Tech-Archive recommends: Speed Up your PC by fixing your registry

Regression is possible, but time-consuming (it's not done automatically as upgrading). I would attempt to move the data tables with SSIS and script the rest of the database and try to run the script on MSDE. I expect you'll find some features that prevent the downscaling that might require rewriting the application--but perhaps just the stored procedures. Of course this assumes you have access to the source file and have George Bush's optimism that it will all work out in time.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
"Paul_Boardman" <PaulBoardman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:01A7763E-A896-43F3-A354-3F906FB54F8E@xxxxxxxxxxxxxxxx
Hi

I am trying to resolve a problem with an SQL database for a known antivirus
application we use. Along the way someone has installed SQLExpress on the
application server and managed to upgrade the database using this.

Starting from the begining....I was resolving a problem with the application
and found that SQLExpress installed. I removed it knowing it shouldnt be on
the server and since then found the application was not working. Further
investigation found that, even though the the company who provided the
application dont support the application running SQLExpress, the application
was working.

I have been through all sorts of ways to get this application working again
and pointing to the upgraded DB but to no avail so I was wondering if there
was some way of regressing the database from SQLExpress back to MSDE 2000?

I think I already know the answer but I thought I would ask.

thanks

Paul



.

Relevant Pages

  • Re: SQLExpress New DB
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... SQLEXpress onto my PC which is running VISTA Home Premium. ... I am pretty certain it is a rights issue, ... Is the database being created on the same ...
    (microsoft.public.sqlserver.connect)
  • Re: Copying tables in SQLEXPRESS
    ... It can copy any data source exposed with a DataReader to SQL Server. ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... I have a program, running in several places, using SQLEXPRESS as database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Starter Kit Application deployment
    ... My ISP offers SQL Server 2005. ... SQLExpress require any special action? ... You will then have to move your database to ... have the connection string aimed to that database, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: newbie: trouble connecting to sql server
    ... SQLEXPRESS it gets its default instance name "SQLEXPRESS" .. ... connect to Sql Server 2005 Express from the IDE of VS 2003 but in the Data ... Link Properties window I get this error message: ... I created a simple database in Sql Server 2005 Express, ...
    (microsoft.public.vsnet.ide)
  • Re: Project 2000 to mySQL Database
    ... Have you got the latest ODBC driver for mysql? ... ODBC database should work. ... >> of SQL Server I should obtain? ... >>>If the problem is in the mySQL database, then upgrading ...
    (microsoft.public.project.vba)