Sample Header Ad - 728x90

Upgrading from excel to an actual database

1 vote
1 answer
119 views
Just started my first internship and I could use some guidance on approaching the project given to me. Simply put, all that needs to be done is to make a database and then transfer the data from a excel spreadsheet and then to automate daily data entry via FTP to the new database. I'm comfortable with SQL and basic database tasks but I'm unsure of the process to create a new database for a small company. Unfortunately I don't have any DBA resources at said company and have no experience on how to manage a database at an organizational level. Considering that the DB will be taking in data automatically every day, I can't host it on my local machine but would rather host it with a cloud service or on-prem w/ remote access right? How would you approach this task?
Asked by John common (11 rep)
Jul 8, 2022, 08:00 PM
Last activity: Jul 8, 2022, 09:53 PM