All geek questions in one place

Move selected data from one server to another SQL Server 2008

I need to move the selected data from 800+ tables in one database to the same 800 + tables in another database on another server. The data that I select is based on the date fields of each table. So, if I say table 1 from 01/01/10 to 01/15/10, then only the data that I want to copy to another table in the server database is indicated. I hope I do not bother anyone. The easiest way to do this?

+3
source share
2 answers

Take a look at SSIS . What you are talking about is very easy to use. Here is a page that talks about using variables in SSIS.

+1
source

If it is a one-time solution, and the target database will be completely new. I would restore the backup from the original database and then delete all records outside the date range that I want in the new database.

, , / SQL Server Management Studio ( Express Edition). , . .

Server1.database.dbo.table1 Server2.database.dbo.Table2.

, SSIS. SSIS . SSIS Visual Studio.

+1

Source: https://habr.com/ru/post/1729156/

More articles:


All Articles