Oracle installation and Migration to MS SQL Server

This is a short blog post about how you can involve in migrating a Oracle based database to SQL Server.

Firstly make sure you have the both latest versions of SQL Server and Oracle.

Oracle -  http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

SQL Server -  https://www.microsoft.com/en-us/download/details.aspx?id=42299

Sometimes installing oracle may be a bit difficult task for you as beginner. So let see how to do it quickly .

First you run the setup and wait for the installation window

After a while you get the setup.So it is time to follow the steps ,
In the first view you can enter email and continue the setup

Then you have a selection of installations. Better to select the first option.

Then they ask you whether the configurations for the desktop environment or a server.Surely select the desktop class and continue it.

Then it is time to create a new user for the oracle database home user.So i recommend you to create a new windows user by selecting the second option.This enables a separate user to work with the oracle.

Then the configurations with settings the paths and global name.

Next is the installation process starts and after the setup completion you get the software installed.

If all the things are successfully completed , then type dbca in the command prompt to create a new database for oracle.Here you can manage the database instances as usually .

Let's create a new database

Next is the prerequisite checks

Then you get a summary before creating the database instance

Finally you are creating the database and ready for the migration .

After that you can insert data by creating the tables .So I will not going to do that, I will continue with the database migration tool.

If you need to manipulate the databases and tables you can download SQL Developer tool and continue the work.

There is a tool called SQL Server Migration Assistance for Oracle - https://www.microsoft.com/en-us/download/details.aspx?id=43689

After the installation you get a icon like below

Open the software and you can see a interface as below

So next is the connecting both oracle and SQL Server to this migration tool by giving each servers credentials. You can do it by clicking Connect to oracle and connect to MSSQL Server buttons in left top corner.

After establishing the connection ,you can access to both databases at once and then select the database you need to migrate and click the button Migrate data or convert schema .You can select some option to be compatible with the data types and other fields information.

So that is the end of this short post and hope you will understand the instructions. Cheers .

WEET (Way of Expressway E Ticketing)

What is WEET? What is is it about ? How was it begun ?

Actually WEET is a mobile Telco application which provides the facility of booking your ticket in ExpressWay .

In TADHACK 2014 Competition it was originally created with the USSD ,SMS ,CAS, and as a web services .

There three parties invovled in this application process

1. User(Passenger )
2. Bus Driver
3. Bus Owner

User (Passenger )can dial the USSD code #771*933# from his Dialog mobile and he access to the E ticketing System .

Then he will get a menu and he can choose his route,time he will pay the ticket amout via this application.

After completing these steps he will get a confirmation SMS with the reference number.

In the same time Bus Driver receive that ticket purchasing details into the tab which is in the bus.So he can get the count total income and other details.

Not only that , also this transaction process can view by the  Bus Owner through a Web Application or a mobile apllication. 

The income directly transfer in to Bus Owner's bank account when the Passenger purchase his ticket.

• So no need to be a in a huge queue until bus reaches
• No need to pay using cash
• Every process is transparent to the bus owner

Watch the WEET Apllication Demo and get a clear idea about how it works

Android Wear

Here we go after a long time I couldn't write any post .Today I'm trying to present you about

Android Wear

 In this werable device we can sear google , check weather , voice replies ant more .The Platform is already build and we can try building apps for this wearable device.

 Here is the steps to begin developing sample application for Android Ware...

It s for AndroidWear[Preview]
You Should follow Instructions
1. Install Android-SDKs
2. Install AndroidWearPreview

Emulator /Eclipse
Source
1. Window > Android Virtual Device Manager > New
2. Set Name >> Choose AndroidWear Round/Square >> Android 4.4.2 /API 19 >> select CPU >> OK >> Launch
3. After Connecting your Android Device AndroidWear Emulator won't recognize ur device
4. Install apk below ** & Run it
5. on Path of ur android-sdks type this into terminal;
|| cd C:\Users\username\android-sdks\platform-tools\ (cmd below)

HTML Code:

adb -d forward tcp:5601 tcp:5601

  Device is coming with several architectures
Try out this concept to your life

 Also you can download sample apps and try it out

AndroidWearPreview -LatestUpdate.APK
ElizaChat4Wear.ZIP (Source Codes)

NotificationWear.ZIP (SourceCodes)
NotificationWear.APK

CameraWear.ZIP
CameraWear.APK


You can watch a demo of Android wearable device from below video ................More details will publish later... Trying to do a app tutorial for this .... Keep in touch with Explorer..