Comments
Sort by recent activity
I believe the rule is that identifiers are actually case-sensitive all the time, but if you don't put quotes around your input Oracle kindly turns everything into uppercase for you... / comments
I believe the rule is that identifiers are actually case-sensitive all the time, but if you don't put quotes around your input Oracle kindly turns everything into uppercase for you...
While quoting the identifiers makes that particular instance case-sensitive, I believe that you can continue to refer to them in a case-insensitive manner afterwards as long as they remain in all upper case. If this is not how it works then please correct me [image] . / comments
While quoting the identifiers makes that particular instance case-sensitive, I believe that you can continue to refer to them in a case-insensitive manner afterwards as long as they remain in all u...
jcossio - is 'P' an actual schema in your database, or a synonym for that schema? / comments
jcossio - is 'P' an actual schema in your database, or a synonym for that schema?
We're very unlikely to implement all of the options from the SQL Server tool in the first version - and some of them just don't make sense in the Oracle world.
If you can tell us which particular options you are likely to want to use, we can prioritise working on those options. / comments
We're very unlikely to implement all of the options from the SQL Server tool in the first version - and some of them just don't make sense in the Oracle world.
If you can tell us which particular o...
You might be looking for the options 'Force column order' and 'WITH element order' - those will let you ignore the order of columns and the order of DML trigger WITH elements.
Are those the attributes you need SQL Compare to pay attention to the order of, or do you mean some other kind of attributes (e.g. index / constraint attributes)? / comments
You might be looking for the options 'Force column order' and 'WITH element order' - those will let you ignore the order of columns and the order of DML trigger WITH elements.
Are those the attribu...
Usually that error is displayed because something that you are trying to synchronize is referring to the object in question - it's being returned from the SQL Server when you try to run the script.
I suspect the most likely cause of the different behaviour between command line and UI is that you have different options set up in the project. Check what options you have selected in the project (in the Edit Project dialog) and try setting them explicitly in the command line? / comments
Usually that error is displayed because something that you are trying to synchronize is referring to the object in question - it's being returned from the SQL Server when you try to run the script....
False 'text was encrypted' on a DEFAULT normally means that for some reason you can't read the sys.syscomments entry for that default. As another co-worker can read the tables fine, that sounds like a permissions issue (rather than a sys.syscomments table corruption issue, the other common cause). Can you check that you have the same permissions as your co-worker? / comments
False 'text was encrypted' on a DEFAULT normally means that for some reason you can't read the sys.syscomments entry for that default. As another co-worker can read the tables fine, that sounds lik...
SQL Compare does not currently support object-level mapping, unfortunately.
(This is because it would require rewriting stored procedures, foreign keys etc that refer to the tables, and we're somewhat reluctant to start rewriting people's objects quite that extensively...) / comments
SQL Compare does not currently support object-level mapping, unfortunately.
(This is because it would require rewriting stored procedures, foreign keys etc that refer to the tables, and we're somew...
Depending what you mean by 'export a table to a txt file', there are two ways of doing it in SQL Compare:
1) If you have the Pro verison, save the database as a script folder (or just create an empty script folder and synchronize the table you want across)
2) Otherwise, compare the database to itself and generate an XML report from the Tools menu (Generate Comparison Results Report).
You can also export creation SQL for single objects in SSMS - just find the object in the object browser and choose the option from the context menu.
Note that neither of these methods will export the data, only the structure. / comments
Depending what you mean by 'export a table to a txt file', there are two ways of doing it in SQL Compare:
1) If you have the Pro verison, save the database as a script folder (or just create an emp...
One problem that running the whole thing and then rolling it all back does solve is working out what is going on when it fails - it can be quite frustrating to get the first error, solve that, and then get another one, whereas if you run the script in an external program and it fails then all the errors that will happen will be reported. / comments
One problem that running the whole thing and then rolling it all back does solve is working out what is going on when it fails - it can be quite frustrating to get the first error, solve that, and ...