Export some SQL tables to 3 party server

Question

Hi any SQL sharks

We would like to export "some tables" from the NPM SQL DB to use for custemers reports.

The question is

can I make a job/tast in the DB that will export those table or what was change in those tables?

ps.

There is custom property  to each one of those node i need data from.

FormerMember · Answer

In Orion Report Writer, there are several options to export data: Text, Excel, PDF and several other formats. You could make custom reports and export them this way.

Also you can use the BCP utility to export tables (with Nodes filtered on the Custom Property) to flat files. You could also use BCP with Task Scheduler to automate and BLAT to send it. A good reference on BCP is here: http://sqlfool.com/2008/12/bcp-basics/

Creating a job with SQL Server Integration Services is another option here.

mcbridea · Answer

I would look into SQL log shipping to the secondary server.