sql server msde: SQLExpress -- sql server msde

SQLExpress

Paul_Boardman
7/16/2007 7:32:03 AM

sql server msde:

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

Re: SQLExpress

William (Bill) Vaughn
7/16/2007 8:54:37 AM

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)
-----------------------------------------------------------------------------------------------------------------------
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server msde group.