Comments
Sort by recent activity
Sorry not too sure what SQL Build Tfs add-on is.
Assuming you don't change the schema or randomly create the schema
You could create a SQL Data Generator project against the schema
Store that project file somewhere.
Then after you have created the temp database
Modify the project file (it's only XML) with the temporary database name that you created and then use the command line of data generator to fill the database?
Hope that helps
David Connell / comments
Sorry not too sure what SQL Build Tfs add-on is.
Assuming you don't change the schema or randomly create the schema
You could create a SQL Data Generator project against the schema
Store that proje...
Hi there, I assume that you want to dynamically create the items in the list below...
<control type="combo" id="SnapShotName" label="SnapShotName:">
<editable>true</editable>
<list>
<item>SnapShot1</item>
<item>SnapShot2</item>
<item>SnapShot3</item>
</list>
<control>
I don't think that this is currently possible, the database connection string is special cased.
Also I don't think that you can write your own extension (although it looks like the code looks in a sub folder for Add-in, I am not convinced that your own code would be loaded.
Sorry about that.
Hope that helps
David Connell / comments
Hi there, I assume that you want to dynamically create the items in the list below...
<control type="combo" id="SnapShotName" label="SnapShotName:">
<editable>true</editable>
<list>
<item>SnapShot1...
Hi there, Sorry to see that you've been having some problems. Just to be clear, is this SQL Backup V9.0.3?
Can you send me your log files perhaps with a screen shot of the GUI, to david.connell at red-gate.com?
Best regards
David / comments
Hi there, Sorry to see that you've been having some problems. Just to be clear, is this SQL Backup V9.0.3?
Can you send me your log files perhaps with a screen shot of the GUI, to david.connell at ...
Hi there,
The account that you are specifying is the Windows Account that the Alert Repository Service runs under. Once installed you can change the Account details in the normal way for all other services.
We verify that the user credentials you give have admin rights. (If running on Win2K I think that we only validate that the username/password is valid.) So it sounds like you are doing the right thing. What I would ask you to do is to log the output of the installation and send me the details. If you run the installer via the SQL Response UI, you should be able to easily get hold of the log. If you are running the MSI directly then please go to a DOS prompt and run the following command
C:\Program Files\Red Gate\SQL Response 1>msiexec -I "SQL Response Alert Repository.msi" -l*v install.log
After it has finished/failed then please send me the log file to david.connell at red-gate.com
Regarding the log file, please note that the passwords are set to hidden so I will not be able see that sort of sensitive data. If you are concerned please read the log file first and anonomize the data, please leave some markers in the file so that I can understand what you have removed.
thanks
David / comments
Hi there,
The account that you are specifying is the Windows Account that the Alert Repository Service runs under. Once installed you can change the Account details in the normal way for all other ...
Hi there,
The forced flad is used internally and is not doing what you expect.
From the command line just add the /f option to force the documentation to be generated.
Hope that helps.
David / comments
Hi there,
The forced flad is used internally and is not doing what you expect.
From the command line just add the /f option to force the documentation to be generated.
Hope that helps.
David
Hi there,
Thank you for your email response.
I presume that you trying to install SQL Compare.
I think that it will take me some time to track down exactly what the problem is.
So in the mean time please install the product(s) you wish directly.
Previously when you sent us the log file, you should have had access to the MSI files directly within that folder.
Please copy the MSI file plus its subfolder to some where like C:\WINDOWS\Downloaded Installations\SQL Compare
then run the MSI from there. (Nb. there is NO UI in this installer, it will by default install into "%PROGRAM FILES%\SQL Compare 6")
That should get you up and going.
Once again thank you for your patience.
Best regards
David / comments
Hi there,
Thank you for your email response.
I presume that you trying to install SQL Compare.
I think that it will take me some time to track down exactly what the problem is.
So in the mean time ...
Hi Petro,
I take it that you are running under Vista,
However what is telling you that it is "no real win-32-application"?
Can you tell me exactly what the error message is please?
It maybe easier to email me with a screen shot directly at david.connell(at sign)red-gate.com
Thanks in advance
David Connell / comments
Hi Petro,
I take it that you are running under Vista,
However what is telling you that it is "no real win-32-application"?
Can you tell me exactly what the error message is please?
It maybe easier ...
Hi there,
It sounds like there is a problem with the executable SQLServerTools.exe.
I have just downloaded the application off the web site and it works fine for me.
I would suspect that somehow it's got corrupted.
The file should be
29,561,576 bytes long
Digitally signed by Red Gate
Version of the file 1.0.0.379
Can you see if the signature is OK? (go to windows explorer, locate the exe right click on it, select the digital Signatures tab and click the Details button. Another dialog should appear saying "This digital signature is OK."
if this is not OK, please download the exe again and try.
If it's OK then please do the following:-
Start up WIndows Explorer and go to the following folder
%TEMP%\Red Gate. Clear down the folder.
Run SQLServerTools.exe. The error box appears. (do not click the button)
Now look in windows explorer and you should see a new folder with a GUID
eg for me I have just got
C:\Temp Folder\Red Gate\{E797625A-C993-4D45-A405-D8C0926C98EC}
please tell me what is in that folder.
If any of the above steps fail (for example %TEMP% does not exist) then please tell me.
Thanks in advance
David Connell
PS It may be quicker to email me directly david.connell at red-gate.com Thanks again / comments
Hi there,
It sounds like there is a problem with the executable SQLServerTools.exe.
I have just downloaded the application off the web site and it works fine for me.
I would suspect that somehow it...
Hi Laurence,
Please explain further
which won't allow me to change the name from local to the name of the server.
Currently SQL Doc does not show a history of changes to a sql object. SQL Doc is designed to compliment source control and not replace it.
Have you checked out SQL Compare 6.0, it now supports comparing by scripts. This may help you in storing your schema in source contol.
Hope that helps
Best regards
David Connell / comments
Hi Laurence,
Please explain further
which won't allow me to change the name from local to the name of the server.
Currently SQL Doc does not show a history of changes to a sql object. SQL Doc is...
Hi Laurence
SQL Doc by default opens the last project created. You can turn off this feature by going to Options from the Tool menu and unchecking "Open most recently used project on startup". If you create a new project you should be able to select a different SQL Server instance. I don't think SQL Doc allows you to change your server instance, only your authentication.
I think that SQL Doc will only display what is available in the SQL Server Database, it does not link into your Source Control system.
Hope that helps
David / comments
Hi Laurence
SQL Doc by default opens the last project created. You can turn off this feature by going to Options from the Tool menu and unchecking "Open most recently used project on startup". If y...