Forum Discussion
jisaac
Helper II
Helper IICopy Job On-Prem SQL Server Error: 'FORMAT' is not a recognized built-in function name. [Moved Post]
Hello, I was trying out the Copy Job (Preview) item as what it is meant to be will be very useful for me. I attempted to pull data from a SQL Server running an older version. I was greeted with t...
lbendlin
Super User
Super Useryou mean, apart from upgrading your database?
jisaacHelper II
Helper IIYes, of course. The program using the SQL server is being replaced, so there's no benefit in upgrading the SQL server version. I also don't know if the program would support the newer version of SQL server. After a year or two, data will stop changing on the program as we'd be completely moved over to the new program. Until then, I need to pull data incrementally from both systems.