Suppose there are 2 servers and you need to transfer something according to the schedule from one server to another and generate an email message.

Options that I know:

1) Alternatively, you can use the SSIS package, but the problem is that with any changes you need to run a heavy IDE-VISUAL STUDIO.

2) Write some simple C # program and put it into a server on the server. The disadvantage is the same as in the first paragraph ... You can’t do anything on your knee. You need to run the IDE and recompile the program.

3) Link the server.

In principle, this will partially solve the problem, however, I can not send mail.

What other ways are there?

  • one
    What you need is actually called replication. And each DBMS vendor has its own tools suitable for their DBMS. There may be replication solutions between heterogeneous DBMSs. - Sergey
  • A simple C # program can be edited in any lightweight text editor, like Notepad. And compile with csc.exe . - Alexander Petrov

0