Activity overview
Latest activity by neilx
Strategy for applications that have config data in the db
SQL Source Control has been working really welll for me so far on my main database.
I wonder if you have any advice on a strategy for versioning a website that stores essential config settings in a...
benhall wrote:
Hello,
Thank you for your post. Our aim for the 1.1 release was to solve a few issues reported by users. We want to provide the best experience when using the application for either a new user downloading SDG for the first time, or for our existing users using the application on a day-to-day basis. As a result, 1.1 does not include any major features, such as being able to ignore a column, however it is still in the pipeline for a later release.
Regards
Ben
Indeed this mainly for date columns where history is being recorded. E. g. startDate and endDate. Although computed, they need to be persisted so have to done with triggers. / comments
benhall wrote:
Hello,
Thank you for your post. Our aim for the 1.1 release was to solve a few issues reported by users. We want to provide the best experience when using the application for eith...
synonym crash?
I have a sproc with a synonym. The synonym uses a server alias which exists and works on the copy db's server instance (actually, it is the copy's server instance).
I can copy the sproc manually, s...
Unfortunately I can't copy from the dialog box or paste images into this post so I can't be sure exactly what the message said.
I was copying live to dev. Since then, I deleted all tables in dev that used the column mentioned and then it synced correctly. I used Data Compare to get the data back in sync. / comments
Unfortunately I can't copy from the dialog box or paste images into this post so I can't be sure exactly what the message said.
I was copying live to dev. Since then, I deleted all tables in dev th...
Datatype change crashes sync
We changed a datatype on a primary key in the live database and now SQL Compare is unable to synchronize with our development copy.
The original datatype was varchar(15) and now it is char(8).
Any ...