Access or SQL Server tables

15 pts.
Tags:
Microsoft Access tables
SQL Server administration
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

———–

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Djj55
    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.
    20 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following