General Database Design

[watts3000]

I was wondering what is the proper flow for designing databases. What I mean is do you design the intial database in acces then export it to something like sql server or oracle. I've heard thats how a lot of people work. What I'm wodering is why don't they just design in sql server or oracle to start. I have also heard of people doing there data bases in access and then exporting to sql server.

 

[EagleKeeper]

The more powerful a database is, the harder it is to modify the internal design.

I use Access to setup everything that I want and then prototype the app.

Afterwords, if the situation demands it, I have used SQL Server for the operational aspects.

 

[UThomas]

SQL Server does not have a built in front end (forms, etc) so you have to use another product (like Access) in addition to it. And since Access 2000 has wizzards to "upsize" the tables it transitions to SQL Server pretty easily.

Thomas