Activity overview
Latest activity by thomask
SQL Compare does not synchronize foreign key names
Hi - I am using SQL Compare Pro 6.2.0.271 to compare a SQL Server 2005 database against a script folder.
The structure is identical with the exception of five tables for whom the the foreign key co...
Hi Simon - thanks for explaining that.
I have removed the extra parenthesis and everything is working fine now.
Cheers,
Thomas / comments
Hi Simon - thanks for explaining that.
I have removed the extra parenthesis and everything is working fine now.
Cheers,
Thomas
Hi Michelle - thank you for the response. [image]
Cheers,
Thomas / comments
Hi Michelle - thank you for the response.
Cheers,
Thomas
SQL Compare is compare with sql file containing a view
Hi there - using SQL Compare Pro 6 we have extracted our database to a script folder.
However when we run a compare between the script folder and the same database SQL Compare marks two views in th...
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
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...
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
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...
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
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 ...
Exporting data to text file
Hi there - I want to export my table data to a text file.
The thing is, I want to store data from certain core tables with my versioning control system and then load them into an empty database.
Mo...
Ok - I will try that. [image]
Cheers,
Thomas / comments
Ok - I will try that.
Cheers,
Thomas
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
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 ...