If I turn on change tracking on a database called Production, can I use the functions to get the change data from another database?
I have tried the following, and also tried replacing the schema with
sys but I don't think this approach is working:
Use [Analysis] GO SELECT Production.dbo.CHANGE_TRACKING_CURRENT_VERSION()
I have worked around it by creating a stored procedure on Production that calls this function. Then I can call that stored procedure from other databases on that SQL Server. But would like to know if there is a more direct way.
I am trying to migrate data from one system to another (over a period of a week or two, then shut down the old system). Change tracking is enabled on the other database. I am limited by the version of SQL Server, CDC requires Enterprise, Developer or Evaluation.