Comments
Sort by recent activity
Unfortunately there isn't a way of changing the script template directly. However you could easily write an application using SQL Comparison SDK that will write the script to a file, and you could edit the version number and so on during runtime.
We have an example on the SQL Comparison SDK site that shows a HTML report produced by a SQL Compare application that uses a XLS template.
See http://labs.red-gate.com/index.php/SQL_Comparison_SDK
Alternatively you could use SQL Compare command line to create a SQL script output, and edit this with something like VBScript or Perl. Of course if you were really keen you could even use a DOS shell script... / comments
Unfortunately there isn't a way of changing the script template directly. However you could easily write an application using SQL Comparison SDK that will write the script to a file, and you could...
The best way is to parse the SQL script with a utility to inject a GO after so many lines. You could easily use a VB or Perl script to do this. / comments
The best way is to parse the SQL script with a utility to inject a GO after so many lines. You could easily use a VB or Perl script to do this.
Check that 'Local and Remote connections' option is set ON within SQL Server 2005 Surface Area Configuration on the remote database please. / comments
Check that 'Local and Remote connections' option is set ON within SQL Server 2005 Surface Area Configuration on the remote database please.
You could switch on the 'Drop primary keys, indexes, and unique constraints' option and create a comparison key between the parent and child consisting of an aggregate of all the row data except for the PK, ignoring the PK's altogether. In this way the parent-child data variance will be seen by SQL Data Compare, and when synchronised
PK identity field will be repopulated automatically. / comments
You could switch on the 'Drop primary keys, indexes, and unique constraints' option and create a comparison key between the parent and child consisting of an aggregate of all the row data except fo...
SQL Compare can only look at encrypted SQL 2000 databases. Unfortunately (or fortunately depending who you are) Microsoft tightened the encryption with SQL 2005, so I would imagine therefore you are looking at SQL 2000 stored procedures. / comments
SQL Compare can only look at encrypted SQL 2000 databases. Unfortunately (or fortunately depending who you are) Microsoft tightened the encryption with SQL 2005, so I would imagine therefore you ...
I have requested by email that you send us your schema for further analysis. / comments
I have requested by email that you send us your schema for further analysis.
It seems that your schema is very big; SQL Changeset is not good in coping with large number of files and can have a performance issues. You can very easily stall SQL Changeset by registering any working folder and then adding or deleting large number of files to this working folder.
The other thing is that you may have a hidden window. Sometimes there are some windows which pop up from source control but are hidden behind SQL Compare, and they need user input so you cannot see them. There is a section about it in the help file:
"SQL Changeset is not responding
Your source control system may display a message box (such as an error notification) or an authentication dialog box behind your current windows; this gives the appearance that SQL Changeset is not responding. Unfortunately, due to the interface provided by the generic source control API, SQL Changeset is unable to access or process these message boxes.
To proceed, you must use Alt+Esc to access the message box, and then clear it, for example by clicking OK. Refer to your source control system documentation for more information on specific errors or messages." / comments
It seems that your schema is very big; SQL Changeset is not good in coping with large number of files and can have a performance issues. You can very easily stall SQL Changeset by registering any w...
If you add an object in the 'Add Objects to Project' you have a tree created on the display panel and a list 'Objects in Project' on the right hand side of the screen. If you click on 'Name' at the top of the list, the objects will appear in alpha order. You can then further deselect objects, which will be removed from the diagram immediately. I think this covers the functionality you require. / comments
If you add an object in the 'Add Objects to Project' you have a tree created on the display panel and a list 'Objects in Project' on the right hand side of the screen. If you click on 'Name' at th...
You could always try running the projects as a command line, and you could then run them either serially in a batch file or in parallel in other windows. / comments
You could always try running the projects as a command line, and you could then run them either serially in a batch file or in parallel in other windows.
The only way to run a very large SQL script in SSMS is to break up the script into small sections with COMMIT statements. This means that you have to parse the script with a utility and insert COMMIT<return>BEGIN TRANSACTION lines.
As transactional integrity may be compromised then you will have to take full backup before running the script of course. / comments
The only way to run a very large SQL script in SSMS is to break up the script into small sections with COMMIT statements. This means that you have to parse the script with a utility and insert COM...