If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Need an advice

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-21-03, 08:43
szdev szdev is offline
Registered User
 
Join Date: Oct 2003
Location: Medellin, Colombia
Posts: 1
Need an advice

Hello,

I have been creating databases for my company for about 1 year using Microsoft Access, and until now it has been enough to fulfill my needs which include several database aplication to handle company work.

But right now, I am planning an Integrated System which will contain Product, Inquiries and Resources Data for the company; as well as the capability of planning the company production and informing the Inquiries status.

What plataform do you recommend me to do so? I need something realiable, but easy to learn.

Thanks in advance,

Santiago Z
Reply With Quote
  #2 (permalink)  
Old 10-21-03, 14:57
GWilliy GWilliy is offline
Registered User
 
Join Date: Jan 2003
Location: Nottinghamshire, UK
Posts: 364
If you're upsizing from Access then MS SQL Server will do the Job

It's a Big Leap in Terms of Cost,Learning Curve & Power

When I did this I remember saying to myself shortly afterwards "Gee Toto i Guess we're not in Kansas anymore"

No Doubt the Oraclers will say go Oracle & the Informixers will say go Informix & the MySQLers will Say go MySQL.

I'll just say Access into SQL Server is Staying with MSoft which is bound to help - for All of MSofts Sins

Try to see the Relationships between Different Application Data & Bear this in Mind for Future Needs.

If your Access DB's are small enough and are logically related - put the tables in one DB.

Theres really no easy Answer for tihs question but from what U Says SQL Server looks better than most.

GW
__________________
"Everything should be made as simple as possible, but not simpler." - Albert Einstein
"Everything should be made as complex as possible, so I look Cleverer." - Application Developer
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On