How can we help you today? How can we help you today?
thomask
Activity overview Badges (0) Posts (4) Comments (7)

Comments

Sort by recent activity
Hi Simon - thanks for explaining that. I have removed the extra parenthesis and everything is working fine now. Cheers, Thomas / comments
  1. Community
  2. SQL Compare Previous Versions
  3. SQL Compare is compare with sql file containing a view
Hi Simon - thanks for explaining that. I have removed the extra parenthesis and everything is working fine now. Cheers, Thomas
0 votes
Hi Michelle - thank you for the response. [image] Cheers, Thomas / comments
  1. Community
  2. SQL Compare Previous Versions
  3. SQL Compare is compare with sql file containing a view
Hi Michelle - thank you for the response. Cheers, Thomas
0 votes
Hi David - your approach is more or less what I had in mind. The reason I am searching for an easy tool to do the data file part is to "ease the pain of change" in the development team. [image] I am currently considering building a quick tool using the free filehelpers library (http://www.filehelpers.com/) Cheers, Thomas / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. Exporting data to text file
Hi David - your approach is more or less what I had in mind. The reason I am searching for an easy tool to do the data file part is to "ease the pain of change" in the development team. I am curr...
0 votes
The reason for having INSERT's would be to make it as easy as possible to use it in an automated build/deploy script. My ambition is to create a build/deploy procedure that given a tag in subversion will do the following: 1) Check-out all my files from SubVersion. 2) Build the application. 3) Create an empty database. 4) Use SQL Compare Pro to create all the tables, SP's, UDF's, etc in the empty database from the script files. 5) Run the data-scripts discuseed in this thread to insert "core" data. I am very close to completing these steps, I am only missing a nice (easy) way of creating the data files for step 5. Cheers, Thomas / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. Exporting data to text file
The reason for having INSERT's would be to make it as easy as possible to use it in an automated build/deploy script. My ambition is to create a build/deploy procedure that given a tag in subversio...
0 votes
Hi David - I would probably prefer to have both versions - ie. one with INSERTs and one as straight CSV both with suitable settings for encoding. The nice thing about INSERTs is that it would work more or less out of the box. With CSV you'd still need some other tool in order to insert it into the table. Regards Thomas / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. Exporting data to text file
Hi David - I would probably prefer to have both versions - ie. one with INSERTs and one as straight CSV both with suitable settings for encoding. The nice thing about INSERTs is that it would work ...
0 votes
Ok - I will try that. [image] Cheers, Thomas / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Saving database schema in version control
Ok - I will try that. Cheers, Thomas
0 votes
Hi Michelle - thank you for answering. This is very interesting, I didn't know what SQL Changeset did. [image] I only have a license for SQL Compare in the standard edition so I cannot try it out. Is it possible to get a temporary upgrade to SQL Compare? Cheers, Thomas / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Saving database schema in version control
Hi Michelle - thank you for answering. This is very interesting, I didn't know what SQL Changeset did. I only have a license for SQL Compare in the standard edition so I cannot try it out. Is it ...
0 votes
Total activity
14
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
3