Comments
Sort by recent activity
Hi @Scarleth Sorry to see you're getting an issue with SQL Change Automation! Can I ask are you using -TemporaryDatabaseServer that has the linked servers setup? / comments
Hi @Scarleth Sorry to see you're getting an issue with SQL Change Automation!Can I ask are you using -TemporaryDatabaseServer that has the linked servers setup?
Hi @ashegrud So when you get the angle brackets (<<) it's saying the object doesn't exist in the source and will therefore be dropped in the target. Unfortunately we don't have any direct documentation explaining it. The documentation here provides common exit codes from the command line: https://documentation.red-gate.com/sc/using-the-command-line/exit-codes-used-in-the-command-line Does this help? / comments
Hi @ashegrud So when you get the angle brackets (<<) it's saying the object doesn't exist in the source and will therefore be dropped in the target. Unfortunately we don't have any direct document...
Hi @ashegrud So when you get the angle brackets (<<) it's saying the object doesn't exist in the source and will therefore be dropped in the target. Unfortunately we don't have any direct documentation explaining it. The documentation here provides common exit codes from the command line: https://documentation.red-gate.com/sc/using-the-command-line/exit-codes-used-in-the-command-line Does this help? / comments
Hi @ashegrudSo when you get the angle brackets (<<) it's saying the object doesn't exist in the source and will therefore be dropped in the target. Unfortunately we don't have any direct documenta...
Hi @PeterDanielsCRB Ah no worries that's okay, one of the developers came up with one scenario in which you could face an issue: - User A creates table 'Foo' on their development database. - User B creates table 'Foo' on their development database, generates a migration, then pushes the change. - User A pulls the change from user B, which causes a problem as table 'Foo' already exists. Gear to hear you're having a smoother experience with the process and new strategy! Thanks for the justification towards your move with VS, I think VS naturally lends itself towards being a better source control experience due to it's nature, but I'll be sure to feed that back to the team! Going forward with this particular issue, should we perhaps revisit it if you experience a similar issue? / comments
Hi @PeterDanielsCRB Ah no worries that's okay, one of the developers came up with one scenario in which you could face an issue:- User A creates table 'Foo' on their development database.- User B c...
Hi @PeterDanielsCRB May I ask, in your original post you mentioned the following at the end " pulled the changes down...and it was messy" if possible could you clarify what you meant by the results being messy? This would help us identify would cause of caused the issue! / comments
Hi @PeterDanielsCRB May I ask, in your original post you mentioned the following at the end " pulled the changes down...and it was messy" if possible could you clarify what you meant by the results...
Hi @PeterDanielsCRB Thanks for the update, I was in the process of double checking with the team about the scenario for your environment. However they're currently stuck on a large bug and unable to reply currently, however we will hopefully be able to reply as soon as possible! / comments
Hi @PeterDanielsCRB Thanks for the update, I was in the process of double checking with the team about the scenario for your environment. However they're currently stuck on a large bug and unable t...
Hi @PeterDanielsCRB I don't think it will be related to what you've mentioned your latest response, also Kendra's resources are really grest and helpful for people of all levels! If possible could we check a couple more things from you if that's okay? So if possible, we would need to know if there was any changes your VCS tab in SSMS, including files external to the SQLProj (read me files etc) Also if you could verify the following:
You're not making any changes to your sqlproj.user file
Assuring that you have both users using the same development on the local machine
If not you can add this to your .gitignore file manually in your repository so it's not accidentally committed (sqlproj.user file). / comments
Hi @PeterDanielsCRB I don't think it will be related to what you've mentioned your latest response, also Kendra's resources are really grest and helpful for people of all levels!If possible could w...
Hi @MarkEaustin Sorry to hear you're experiencing this issue! In order to troubleshoot I'd need some more information from you, what I'll do is reach out to you via a support ticket. / comments
Hi @MarkEaustin Sorry to hear you're experiencing this issue!In order to troubleshoot I'd need some more information from you, what I'll do is reach out to you via a support ticket.
Hi @Bugmeister This looks like it might be a potential bug, I'll need some more resources from you to escalate this to the development team. What I'll do is reach out via a support ticket! / comments
Hi @Bugmeister This looks like it might be a potential bug, I'll need some more resources from you to escalate this to the development team.What I'll do is reach out via a support ticket!
Hi @DaveFirth , Sorry to hear you're experiencing this issue! Please correct me if I'm wrong, but as you mentioned you're using SQL Change Automation as well, could you look inside the .sqlproj file and check if there's an extra reference to the sql file creating that user? If that's not the case let me know and we will troubleshoot further! / comments
Hi @DaveFirth ,Sorry to hear you're experiencing this issue!Please correct me if I'm wrong, but as you mentioned you're using SQL Change Automation as well, could you look inside the .sqlproj file ...