Home > IT Answers > Microsoft Windows > Access or SQL Server tables
Imjnice
15 pts.
 Access or SQL Server tables
Access Tables, SQL Server administration, SQL Server Table Migration, SQL Server tables, SQL tables
Yes I am consultant for a small business, and currently they have a Access database that works pretty decently. At the current situation, the owner needs another database. I really do not want to have to ask the developer to keep creating different databases that includes him having to put more separate tables on the server for the new database. I wanted to know, for future growth, would SQL be better to implement being that the owner needs another database? I mean no telling how many more databases she may need.

Software/Hardware used:
ASKED: December 14, 2010  4:02 PM
UPDATED: December 16, 2010  12:55 PM
RELATED QUESTIONS
Answer Wiki:
Yes, future growth would be best handled with SQL Server. Depending on the amount of data, you could start with the express edition and upgrade to standard or some other edition when needed. -----------
Last Wiki Answer Submitted:  December 14, 2010  4:31 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Just a reminder NOT to use the Microsoft defaults when moving the data from Access to SQL. They did that here and now we have zip code as type Float.

Djj55
 20 pts.