I have mdbe 2000, how do I install sql 2000 on top of (or replace) it and not break apps?
Posted on 2006-04-28
I am running an application, Timematters 7 enterprise, that came with the complimentary MSDE 2000 database engine. I want to install the regular sql 2000 on this machine, but dont know if i just install it whether it will break my application, or if i need to reinstall the application, uninstall MSDE or what? Also, since I am totally new to all this, and my IT skills are limited, how do i figure out how the sql works basically? I see that my app has its datafiles listed as being located in a particular path and folder, but as I understand it, all the data really gets stored in tables created by the sql server. Any reference to how this all works would be appreciated.