Just looking for some direction here....
I am supporting a small web app and manage the database as well. I have full access to the web server, but only access to the DB via Management Studio. (Currently, no other access to the SQL box)
I have to update the system with fresh data twice a week. It appears that the only way I can import the data (flat file) into a table on the production server is via a script. It's a HUGE pain. (Generating a script from my local DB, connecting to the remote DB and running the script which contains the CREATE TABLE statement and about 15K INSERT statements.)
Just wondering what the best practice is here? Should I contact the DB Admin and ask for some remote access?
Any thoughts? Hoping to make this is quick, simple process.