MSDE2K and SQL2K DEV co-exist?

[paulray]

Read some threads but can't get sure answer if they can co-exist. Running SQL2K-DEV on laptop and want to port/test our app to MSDE2K. Can it be done?
Thanks

 

[paulray]

Need to elaborate. Not really looking for MSDE, but SQL Database Engine. (too many names, too many versions). Do I need to run on separate machines to test an app that should run whether SQL2K or SQL2K Engine?
Thanks

 

[TheBugSlayer]

Do you need to know whether a DB created SQL Srv 2K Enterprise Edition can run in a Developer's Edition?

You can easily upgrade an MSDE DB to SQL DB, but the other way around is not 100% true; it depends on what types of objects you have created and used in the DB.

You need to elaborate more.

 

[paulray]

Thanks for getting back to me. The SQL tables are simple, with basic relationships, there are no triggers, but there are some SP's used to query data. We considered Access for the "low end" but prefer to just stay within the SQL framework.