Activity overview
Latest activity by larus
SCO Command line: a way to include only Tables and Views
I'm trying to set a automated deployment of db objects using Schema Compare for Oracle, command line utility SCO.exe. Is there a way to include only tables and views in comparison? I'm trying to de...
Thanks, it worked when I assigned it to SQL Query Editor! Now both works (Shift+F5 and Ctrl+Enter) for executing the current statement. / comments
Thanks, it worked when I assigned it to SQL Query Editor! Now both works (Shift+F5 and Ctrl+Enter) for executing the current statement.
How to change key binding for 'Execute Current Statement'
I would like to change the key binding for 'Execute Current Statement' from the default 'Shift+F5' to 'Ctrl+Enter'. How can I do that? I'm using SQL Prompt 7.3.
Bug with TO_DATE function
When comparing Oracle schemas, the deployment wizard gives me an INSERT statement where for date columns TO_DATE function like this:
INSERT INTO SCH.rg_temp_1087916431_0(ACTIVATION_TIME) SELECT TO_...
Changing database password locks db account?
I changed my database password and now when I try to fetch data from source control (SVN repo), my db account gets locked. That maybe because source control tries to access db using my old password...
Is there a way to see type of a relation?
Is there a way to see what attributes are linked on tables (Primary key - foreign key) and what is the type of the relation (1:1, 1:N etc)?
Is there a point for creating normal branches, tags, trunk?
I'm planning to put my databases under version control using SQL Source Control. Is there a point to create a normal project structure under repository project file, eg. branches, tags, trunk and p...
Yes, I found the solution for this problem: In addition, if running on SQL Server 2008, you also need to GRANT VIEW SERVER STATE TO <user> / comments
Yes, I found the solution for this problem:In addition, if running on SQL Server 2008, you also need to GRANT VIEW SERVER STATE TO <user>
We are having the same problem. In some databases the objects are displayed and in others not. I'm db_owner in each database. How to solve this problem? / comments
We are having the same problem. In some databases the objects are displayed and in others not. I'm db_owner in each database. How to solve this problem?