How can we help you today? How can we help you today?
einman33
Activity overview Badges (0) Posts (0) Comments (5)

Activity overview

Latest activity by einman33

Great work guys checking it out now / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Features available in next release of SQL Compare
Great work guys checking it out now
0 votes
David Atkinson wrote: Regarding the 'migrations' feature, would you be able to fill in our survey? David Done, let me plug in with SQL Source Control and post in update. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. SSMS-Tasks-Generate Scripts - add Drop if exists to script
David Atkinson wrote: Regarding the 'migrations' feature, would you be able to fill in our survey? David Done, let me plug in with SQL Source Control and post in update.
0 votes
David that sounds very interesting and will probably be an early adopter once it comes out. Our entire development group is standardized on TortoiseSVN front end with a Subversion back end. I have SQL Source Control installed and talking to Subversion just have not gone much beyond that. Hopefully there will be some beta opportunities as I would love to take it out for a test drive. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. SSMS-Tasks-Generate Scripts - add Drop if exists to script
David that sounds very interesting and will probably be an early adopter once it comes out. Our entire development group is standardized on TortoiseSVN front end with a Subversion back end. I have ...
0 votes
David Atkinson wrote: Do you often come across instances when you run scripts where tables sometimes exist and sometimes don't exist in the target? I'd be interested in understanding how situations like this arise so we can better solve the issue. David Sure thing David. My situation is a continous development environment on a large platform with multiple developers creating SQL articifacts. We have quartlerly releases, and I want to apply the same Database scripts that will be run during our production night deployments during every QA release. These QA releases occur multiple times a day. The benefit for me is the script on deploy night have spent months of QA, and there are limited errors do to deployment issues. Obviously the first time I run the script in our QA environment it will be a CREATE, but then the same script will run over and over again untill production deploy, hence the need for the ALTER check. Does that make sense at a hight level? I have created a deployment tool using C#, Red Gate API tool stack and the SQL Compare API and it runs great. The only custom coding needed was for the ALTER vs CREATE checks. Would love to dump this custom code if you guys can come up with a solution, as I am sure your RegEx experts might do a little better than I did My end game for this is for deployments to be a few F5 pressess, and minimal hands on from a human. Before my tool we compared our QA to prod environemnts via Snapshots. This worked fine, and left in a much better place than before. But there was still a human involved making judgement calls (For example, was the difference shown part of a hotfix out of cycle or new developemnt, not hard to get this wrong in a large development effort where communication between teams is not always the greatest) / comments
  1. Community
  2. SQL Compare Previous Versions
  3. SSMS-Tasks-Generate Scripts - add Drop if exists to script
David Atkinson wrote: Do you often come across instances when you run scripts where tables sometimes exist and sometimes don't exist in the target? I'd be interested in understanding how situati...
0 votes
What about for table objects: IF EXSITS....ALTER TABLE else CREATE TABLE? / comments
  1. Community
  2. SQL Compare Previous Versions
  3. SSMS-Tasks-Generate Scripts - add Drop if exists to script
What about for table objects: IF EXSITS....ALTER TABLE else CREATE TABLE?
0 votes
Total activity
7
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2