Activity overview
Latest activity by AndrewBA
Does SQL Prompt 4 work with SSMS 2012?
Hi,
I have recently installed SQL Server 2012 on my machine, however the SQL Prompt 4 menu is not in the SSMS 2012 menu bar. I have uninstalled and re-installed SQL Prompt 4 but it still only appe...
I have the same question. Can I source control the <relational_index_option> parts of my index specification? / comments
I have the same question. Can I source control the <relational_index_option> parts of my index specification?
As a follow up to this; I automatically create a "CreateDatabaseObjects.sql" script from the SourceControl db object scripts in SVN. The create objects script was in the database directory that SourceContol is linked to and I think that SourceContol found it and threw the duplicate objects error. / comments
As a follow up to this; I automatically create a "CreateDatabaseObjects.sql" script from the SourceControl db object scripts in SVN. The create objects script was in the database directory that So...
Thanks for the response, this was indeed the problem. / comments
Thanks for the response, this was indeed the problem.
I have also received this error this morning - strange because everything seemed to be working OK on Friday afternoon.
I am fully up-to-date with Windows updates, and have tried rolling back to v1.1. Other developers attaching to the same SVN repository are having the same issue.
I created a new SVN folder and linked my database to it. This worked for a while and then came back with the same error.
My instance default collation is Latin1_General_CI_AS, my db collation is SQL_Latin1_General_CP1_CI_AS.
The error only happens on 1 of my SourceControl db's.
What exactly does 'Ensure that case sensitivity options are set correctly and all object creation scripts are valid' mean and how can I proceed?
Windows 7 Pro SP1 x64, SQL Server 2008, SVN, SQL Source Control 2.1.0.31 (I recently updated to the 14 day trial of this) / comments
I have also received this error this morning - strange because everything seemed to be working OK on Friday afternoon.
I am fully up-to-date with Windows updates, and have tried rolling back to v1....
Source control server configurations
Hi All,
Has anyone come up with a way of source controlling server configurations? For example, I have just enabled file stream access on my dev machine and would like to be sure that this setting...
Hi Anu,
Thanks for the response. My SQL Compare details are;
SQL Compare 8.1.0.360
511-002-112270-60A5
Professional Edition
Regards,
Andrew / comments
Hi Anu,
Thanks for the response. My SQL Compare details are;
SQL Compare 8.1.0.360
511-002-112270-60A5
Professional Edition
Regards,
Andrew
Can SQL compare create filegroups?
I think that the answer is a straight 'No' because I can't find anything to this effect.
What I would like to do is compare databases with different filegroups and generate scripts to add missing f...
Thanks for the response Eddie.
I had already considered your solution, which means editing the 'Number of rows to generate' for every table in my database every time I want to complete a load. To reduce this overhead I thought that I'd save each configuration as a separate project but then of course I've got to keep all my projects in sync if I make refinements.
I was wondering if I could create one SQL Data Generator project and use it multiple times on the same database without editing the SQL Data Generator project and without breaking any primary keys or unique constraints?
I suspect that I'm asking for functionality beyond that which should be expected of a v1 release. Either way, SQL Data Generator is a great application and has already proved useful in my organisation. Keep up the good work! / comments
Thanks for the response Eddie.
I had already considered your solution, which means editing the 'Number of rows to generate' for every table in my database every time I want to complete a load. To ...
Multiple loads for same project
Hello!
I have a requirement to gradually fill a database with data, the scenario would be;
a) Load x thousand rows of data into the db
b) Test the application
c) Repeat until we break something
As ...