I have a table of static data that needs to be uploaded weekly. The management tools only appear to provide the ability to load a backup for the entire database. Is there a recommended way to re-load a single table?
There is no single table object restore function in SQL Server - this RDBMS just doesn't support this feature which explains why there's nothing like this surfaced in the control panel. I can think of a couple of options however: If you fancy getting your hands on code and it fits your use case, you could develop your own data import routine. This is definitely not beyond the realms of what's possible with ASP.NET / ADO.NET. Alternatively you could develop a local application to import this data with a direct connection to the remote db. OR You could just directly connect to your database with SSMS and manually 'smash' the data into the target table manually when you need to. If you like that idea, see this
Have you tried using the Generate Script feature that comes with SSMS? This will allow you to run a command that will basically script out a specific table/object you want, and run it against the target SQL server. http://technet.microsoft.com/en-us/library/ms178078(v=sql.105).aspx
