Forum Discussion

jisaac's avatar
jisaac
Icon for Helper II rankHelper II
1 year ago

Copy 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...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

I don't think Microsoft will want to support that legacy setup.

jisaac's avatar
jisaac
Icon for Helper II rankHelper II
1 year ago

Then is there a workaround I could do on my end?

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    1 year ago

    you mean, apart from upgrading your database?

    • jisaac's avatar
      jisaac
      Icon for Helper II rankHelper II
      1 year ago

      Yes, 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.