Comments
Sort by recent activity
You may upload your screencast to ftp://Z25737:3ugFXxA1@supportftp.red-ga ... ers/Z25737 if you are able to use FTP.
Thanks! / comments
You may upload your screencast to ftp://Z25737:3ugFXxA1@supportftp.red-ga ... ers/Z25737 if you are able to use FTP.
Thanks!
Is this when you exec sp_addextendedproperty on the database in an SSMS query window to add an MS_Description at the same time SQL Doc's preview window is open? I tried that and it was not exhibiting the same lock-up in my case. / comments
Is this when you exec sp_addextendedproperty on the database in an SSMS query window to add an MS_Description at the same time SQL Doc's preview window is open? I tried that and it was not exhibiti...
Hello,
Just trying to work out what the issue is - if I had to sum it up in one sentence, would this be accurate?
I would like SQL Data Compare to not script data for a column of a row when there is no difference in that particular column in that particular row.
Assuming that you actually did not go into the mappings and exclude that column from being compared - in that case the update statement should not include that column at all. You can exclude a column from a comparison like this: http://documentation.red-gate.com/displ ... +and+views / comments
Hello,
Just trying to work out what the issue is - if I had to sum it up in one sentence, would this be accurate?
I would like SQL Data Compare to not script data for a column of a row when there i...
Hello,
This is not something I have any experience with, but you may want to get a listing of the table usage from SQL Server. Here is one description of a query you can use to do that. http://www.mssqltips.com/sqlservertip/1 ... -database/
Usually anything with "UnstableSamples" in the table name is going to be a big one.
Hopefully this helps. / comments
Hello,
This is not something I have any experience with, but you may want to get a listing of the table usage from SQL Server. Here is one description of a query you can use to do that.http://www.m...
In SQL Doc 2, when you edit an extended property (description) on a column, it opened a dialog where you could save the change or cancel. I do not see the ability to edit and save multiple extended properties at one time.
If SQL Doc 3 is "hanging" when attempting to edit the extended property, can we please identify that as the issue as there is more chance of getting that fixed than "rolling back" a UI change that has been determined to make a cleaner, more usable UI. / comments
In SQL Doc 2, when you edit an extended property (description) on a column, it opened a dialog where you could save the change or cancel. I do not see the ability to edit and save multiple extended...
Can you please clarify "multiple edits"? I do not fully understand what/where you are editing. Is this about editing extended properties directly on the SQL Server?
As SQL Doc is almost completely rewritten for v3 it would not be possible to simply go through SQL Doc's code and compare to see what has changed and solve the problem that way. So from my perspective I have to throw away comments about how it used to work in the previous version and concentrate on what/where the problem is in this version, try to reproduce it, and pass the reproduction on to development so they can do whatever they do. / comments
Can you please clarify "multiple edits"? I do not fully understand what/where you are editing. Is this about editing extended properties directly on the SQL Server?
As SQL Doc is almost completely ...
I'm sorry that SQL Doc doesn't seem to be performing well. Updating the description runs a query on the database that updates an extended property on the database that you are documenting. it should be fairly quick, but it sounds like the SQL Server is not processing the query in a timely fashion. Is this behavior evident on all databases and servers, or just one? / comments
I'm sorry that SQL Doc doesn't seem to be performing well. Updating the description runs a query on the database that updates an extended property on the database that you are documenting. it shoul...
I came up with this, but it needs to make a connection to the server for every record.
# Basic generator template
def main(config):
# config["column_name"] is the column name
# config["column_type"] is the column datatype
# config["column_size"] is the column size
# config["n_rows"] is the number of rows
# config["seed"] is the current random seed
import System
import System.Data
import System.Data.SqlClient
str_connection="Data Source=localhost;Initial Catalog=Database2;Integrated Security=SSPI"
sql_connection=System.Data.SqlClient.SqlConnection(str_connection)
str_command="SELECT TextField FROM Table1 WHERE TextField LIKE '%"
str_command+=COUNTRYNAME # Where COUNTRYNAME is a field from the table
str_command+="%'"
sql_command=System.Data.SqlClient.SqlCommand(str_command)
sql_command.Connection=sql_connection
sql_connection.Open()
sql_datareader=sql_command.ExecuteReader()
a_value=""
while sql_datareader.Read():
a_value=sql_datareader.GetString(0)
sql_datareader.Close()
sql_connection.Close()
return [a_value]
/ comments
I came up with this, but it needs to make a connection to the server for every record.
# Basic generator template
def main(config):
# config["column_name"] is the column name
...
Hello,
SQL Data Generator has the ability to run a Python script, so if you have a Python script, variable declarations typically begin with the dollar-sign ($). The question must be, how to get a generated column value and use that in a SQL query. This sounds like you would need a combination of two generators - cross-column and SQL statement.
The best solution I can think of for this is to use the Python generator, get the column name into a variable and use Python to get the data. / comments
Hello,
SQL Data Generator has the ability to run a Python script, so if you have a Python script, variable declarations typically begin with the dollar-sign ($). The question must be, how to get a ...
To be more precise, Data Compare for Oracle does not compare complex object types - ie datatypes that are actually composed of a list of properties having their own name and datatype. It's not specifically a lack of support for spatial objects, it's an inability to know how to compare types of data that are more complicated than just a collection of bytes that are stored in a predictable way.
For all intents though, Data Compare for Oracle would not be ab le to compare these spatial types because they use object types to hold the information and Data Compare does not support object types.
It's something that Red Gate are looking to support. / comments
To be more precise, Data Compare for Oracle does not compare complex object types - ie datatypes that are actually composed of a list of properties having their own name and datatype. It's not spec...