Replicating tables in SQL Server

[Marc Brown]

I have a table that is used for reporting, the problem is that the data in the table is refreshed every 30 minutes with a bulk insert. I am trying to find a way to have two tables that are mirror images of each other and when the loading table is loaded, then the table assumes the identity of the reporting table. The basic prinicpal is I need to have the table be available almost all the time and when the bulk insert is happening, users cannot query. Any help would be greatly appreciated.

Thanks in advance
Marc Brown

[Michael Hotek]

The simplest way? Create 2 views. One over each table. Have the app hit one of the views. As soon as the data load is done, rename the views so the app is now pointing to the other view.