Comments
Sort by recent activity
Hi David,
thank you for your reply.
I agree with you the complexity of supporting multiple branches but in our case we use branches only as a safe way to deploy small bug fixes in production.
I know that most users use multiple branches and then merge everything back to trunk but we don't have that complexity. We have just one branch at time.
I tried to solve the problem using svn:external from subversion to have always the same URL but it seems not working with SQL Source Control.
Do you have any suggestion?
Best Regards,
Gabriele / comments
Hi David,
thank you for your reply.
I agree with you the complexity of supporting multiple branches but in our case we use branches only as a safe way to deploy small bug fixes in production.
I kno...
Hi,
I did additional tests and my first impression was wrong. Actually the problem is related with URLs in extended properties. I'm using separate branches repository for each version we deploy and because the URL between source database and target database are different (for instance 1.1 in dev and 1.0 in production) the migration script get ignored.
This s a big problem for us because we need to manually update that URLs to make migration script happens.
I think the only workaround could be to use alias for subversion URLs but I'm not sure that exist.
Best Regards,
Gabriele / comments
Hi,
I did additional tests and my first impression was wrong. Actually the problem is related with URLs in extended properties. I'm using separate branches repository for each version we deploy and...
Hi,
I was able to spot the issue and I found a workaround for that.
In my case the table column was an integer and was committed with some data already and when I tried to change the column type to Guid but keeping the same column name probably the software is trying to compare existing data in source control with the ones from database and it was failing to convert an integer into a Guid.
My workaround was just to unlink static data and commit it. After that I just link again static data and everything work.
Best Regards,
Gabriele / comments
Hi,
I was able to spot the issue and I found a workaround for that.
In my case the table column was an integer and was committed with some data already and when I tried to change the column type to...