all groups > sql server msde > november 2004 >
You're in the

sql server msde

group:

MSDE as prototype


MSDE as prototype Marc Connolly
11/10/2004 7:55:26 AM
sql server msde:
I have reporting responsibilities in a big company within a marketing
department and use DB2 queries and Access then excel to create sales and
profit reports for 3 different sales divisions. We have a "SQL server group"
in our division but internally we can not rapidly develop applications due
to inexperience and overworked resources. For example, if a SQL server
application is proposed it rarely gets beyond the discussion phase with
finger pointing on requirements and debates about not duplication data
between the AS400's and SQL.
I need to get away from DB2 and Access and I think we will eventually figure
out what we are doing.

I want to create a front end using .net connected to MSDE where I develop
the schema that would make sense when it is moved to SQL server. I am not a
dba so I really just want to create the basic design.


Question : Does this approach make sense? What is the best way to prototype
in this situation? Is this legal to do ?


RE: MSDE as prototype Ross
11/10/2004 11:35:02 AM
Sounds like a good start to me. You will be able to use the Server Explorer
tabs in Visual studio to create / manage your tables in the MSDE database
just like a full SQL Server database. You app won't know the difference when
you swap in the future.

And the drag-and-drop SQL components from the toolbar can really accelerate
your development for a simple prototype.

And legally - I'm quite sure you're fine (though my opinion on legal matters
doesn't mean much)

- Ross

[quoted text, click to view]
AddThis Social Bookmark Button