Monthly Archives: March 2015

Removing Cached SVN Credentials

The credentials are stored in files under this directory: ~/.subversion/auth/svn.simple/ Remember if you remove them all, you will not be able to do svn update without being prompted for credentials.

Posted in Uncategorized | Leave a comment

How to copy data between two schemas on Oracle?

If you want to copy data from table b on schema1 to schema2, you need to connect to schema2 and grand select permission first: grant select on b to schema1; Then you can connect to schema2 and copy data using … Continue reading

Posted in Uncategorized | Leave a comment

Import data from Oracle to SQL Server

1. To be able to do it, we need to install Oracle client on the server where SQL server is installed. We have a windows 2008 R2 server and I installed Oracle 12g client on it. 2. Copy the tnsnames.ora … Continue reading

Posted in Uncategorized | 1 Comment

SQL Server User Setup

I was trying to move my oracle database to SQL Server. The first thing I need to do is to create a database user. Here are the steps: 1. You need to enable SQL Server Authentication. The default of 2008 … Continue reading

Posted in Uncategorized | Leave a comment