I'm working on an asp.net vb project using sql2000. Users request me to create a protype for their review and training use. Can I deploy my project with only dlls forthe front end and an MSDE backend created from a script of the original Sql2000 database? Is there any potential discrepacy or problem with my prototyping plan? How can I copy my original database from sql2000 to msde?
Thanks for any help.Yes, Enterprise Manager and Query Analyzer can be interfaces to MSDE.
Yes, you can use MSDE as the back end for development but deploy to a SQL Server 2000 database.
When I mean "can" I mean "technically possible". I am not 100% sure of "legally possible". The licensing information for MSDE is fairly confusion, IMO.
The SQL Server 2000 Developer's edition is made specifically for situations like yours. It is $49.95 US and would give you the EM and QA tools plus the database. SeeDevelopment Edition Licensing.
I think the best way to transfer the data and schema would be to restore a backup.
Terri
No comments:
Post a Comment