1

Topic: Question on outswapping

Hello!
With new 2018!
Assume I wrote a SQL query which consists of two parts. The first part of request preempts such given as shipments, sales, resets on days for the last 60 days. Plus still some reference tables. The second part of request does difficult calculation of this data. The second part of request is adjusted, as the request on the certain logic is not added still. In test basis I can write and launch requests. If the request is ready, I give to its employee who has rights to outswapping from working basis. As the second part of request is adjusted, permanently it is necessary to launch anew from working basis.
Whether probably to make so that the data of working basis were preempted, saved, and then in test basis to obtain this data and then to launch the second part of request? There can be what  a function special there is for these purposes in the program of SQL Server Management Studio, or what  a utility, or what that another?

2

Re: Question on outswapping

There are such functions, truth to SSMS they do not concern. Are called SSIS, Jobs and other pieces for automation of the regular requests.

3

Re: Question on outswapping

ferzmikk;
Get in fighting basis  with the right of performance of some procedures, but not with the rights of reading of the necessary tables/view, give it just causes in test basis, create SQL Agent Job and on daily performance in the mornings.
If the data "became rotten" because of failure of outswapping or it is necessary to update urgently in the afternoon - the user who works in test, can update through start of the procedures prepared for it in the fighting.
In procedures to deliver a cycle on the necessary depth on dates that from loading the fighting did not lay down, plus to restrict depth. Well or rigidly to set the necessary floating range of dates. For the last 60 days from date of start of procedure (getdate ()).

4

Re: Question on outswapping

Whether

ferzmikk wrote:

Probably to make so that the data from working basis was preempted, saved, and then in test basis to obtain this data and then to launch the second part of request?

insert test.tbl select from prod.tbl