Hello,

We have been assigned a task, which i am not sure is feasible or not and seems a good question here, but i will still like if someone has any suggestion or done this before:

On one of the server we have this SEPM embedded database hosted  on SQLAnywhere , basically an app from Symantec to track various actvities and updates the same on their hosted db.

Now, there is a requirement that we fetch the data from this SEPM (SQLAnywhere) database and update on SQL Server, creating a new database there, every 4 hours.

So basically its sort of refresh from SQLANywhere database onto SQL server (2012), every 4 hours.

Please help on how to achieve this?

Hi MAXKA,

You can firstly create a linked server to SQL Anywhere in SQL Server, and create a job executing the task that refresh data from SQL Anywhere onto SQL Server using OPENQUERY.  For more details about how to create a linked server for SQL Anywhere, please review this similar blog.

Another option for your scenario is to create SSIS packages to fetch data from SQL Anywhere database to SQL server, and create a job to run these SSIS packages in SQL Server. For more details about how to use SSIS to fetch data from SQL Anywhere, please review this similar blog. For more details about running SSIS packages via SQL Server Agent job, please review this article.

Thanks,
Lydia