Using dbForge Schema Compare for SQL Server version 5.0.57 on Windows 10.
Source and target are Sql Server 2019.
1. New Schema Compare. Set Source and Target databases.
2. Compare indicated differences (as expected).
3. Synchronized to a file.
4. Launched SSMS version 15.0.18384.0
5. Opened the synchronize file generated in step3.
6. Ran script (ie Execute).
7. Generated PRIMARY KEY constraint as well as many invalid column name in different stored procedures.
Since all the changes necessary to make the target match the source were in the script file, I'm not sure how these errors are occurring. Also, how do I proceed ?
I am a new Schema Compare user so bear that in mind.
Thanks.
Sync Error - Confused
Re: Sync Error - Confused
OK. This is where things went off the tracks I believe.
I had a table in the source database table (captured_events) that had a field named type_id. I had the exact same table (captured_events) in the target database that did NOT have the type_id field. Also, type_id is part of the key in the source database table captured_events.
How I "fixed" it.
In the target database, I manually added the type_id field. I then reran the Schema Compare. Synced to a file and ran that file in SSMS. Seems to have worked.
Maybe I'm just a newb.
I had a table in the source database table (captured_events) that had a field named type_id. I had the exact same table (captured_events) in the target database that did NOT have the type_id field. Also, type_id is part of the key in the source database table captured_events.
How I "fixed" it.
In the target database, I manually added the type_id field. I then reran the Schema Compare. Synced to a file and ran that file in SSMS. Seems to have worked.
Maybe I'm just a newb.
Re: Sync Error - Confused
Hi there,
Can you please try running this s script in internal SQL doc in Schema Compare not opening script in SSMS- and let us know if you will get any errors?
https://prnt.sc/jOJ2OlH06tPT
Also please make sure that in the synchronization script you trying to open in SSMS the correct connection and database is chosen (server and database should be the same as in Schema Compare on page Source and Target.
https://prnt.sc/U8AeQTgoxdDQ
Also, please send us screenshot of the errors you are getting.
Regards,
Devart Support
Can you please try running this s script in internal SQL doc in Schema Compare not opening script in SSMS- and let us know if you will get any errors?
https://prnt.sc/jOJ2OlH06tPT
Also please make sure that in the synchronization script you trying to open in SSMS the correct connection and database is chosen (server and database should be the same as in Schema Compare on page Source and Target.
https://prnt.sc/U8AeQTgoxdDQ
Also, please send us screenshot of the errors you are getting.
Regards,
Devart Support
-
- Posts: 1
- Joined: Thu 23 Jun 2022 23:52
Re: Sync Error - Confused
Thank you! I have already run the commands in the document you sent, they work fine.Raudar wrote: ↑Mon 28 Mar 2022 09:35 Hi there,
Can you please try running this s script in internal SQL doc in Schema Compare not opening script in SSMS- and let us know if you will get any errors?
https://prnt.sc/jOJ2OlH06tPT
Also please make sure that in the synchronization script you trying to open in SSMS the correct connection and database is chosen (server and database should be the same as in Schema Compare on page Source and Target. five nights at freddy's 2
https://prnt.sc/U8AeQTgoxdDQ
Also, please send us screenshot of the errors you are getting.
Regards,
Devart Support