Share via

Different version database sync

Anton Yurukov 96 Reputation points
2021-04-05T12:45:59.893+00:00

I have a database of an application restored in a environment that runs a newer application version than the database version.
The databases contain hundrends of tables, most of which are same.

I know the application expect to find additional fields and maybe tables not existed in the database early version.

I use SQL server version 13.0.5865.1

How I can keep the original/empty environment database schema with old version database data?

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments

Answer accepted by question author

Anton Yurukov 96 Reputation points
2021-04-06T06:40:30.163+00:00

Well after import the old backup with the data - run Syncronize database from Visual Studio Dynamics 365 menu and its work :)

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator
    2021-04-05T15:44:09.11+00:00

    I am not sure that I understand your question. Are you asking how you can run the newer version of the application with the old schema of the database? That sounds difficult to me, but it would be better to ask that question to someone with knowledge about your application.

    I can't but see that you will need to find a script that upgrades the database to match the version of the application.

    Or can you clarify your question?

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.