On a nightly basis, this table gets rebuilt in a temporary database. Once the table has been built and scrubbed, i need to move it into our webservers db.
I'd like to do this with minimal interuption to the website.
Possible techniques:
1) I could set up a DTS package to copy the table object overwriting the destination table
2) I could export to a flat file and then bulk import into the live table (after truncating it)
3) I could run a process to update smaller chunks of data at a time running delete queries and insert queries.
Anybody have a thought on the best way to do this so that the web users would be virtually unaware that anything was happening ?Is the webserver's db.. like at a remote location?
I'd go with loading that temp db to another temp db on the webserver, and reverse engineer it.|||The temp DB is on the same SQL server as the webservers DB.
so the questions remains....
What's the best way to move a table from DB to DB with minimal interuption to the user?|||I use DTS for almost the same thing, but my table is < 1gig. I dont notice any slowdown, but I probably only have 5 current users at any instance.|||are you object copying or bulk inserting ?
