How can we migrate Oracle database to Microsoft Access?

How do I migrate an Oracle database to Microsoft Access?

Vsrameshkumar025 pointsBadges:

Migrating data from Microsoft Access to SQL Server 2000

I want to transfer data from access to SQL table and vice versa through Windows service. So, please help me.

VBNET5 pointsBadges:

Oracle 9i Migration from Solaris to AIX

Hi, We have to migrate the Oracle 9i Database from Solaris 2.8 to AIX 6.1. There are two databases of 500 GB and 1.5 TB respectively to be migrated. I did go through an article from Maria Anderson (Production DBA, Autodesk at...

SolnSeeker5 pointsBadges:

backup and recovery

details about backup and recovery and suppose i was import data from oracle database. we can export to another database(not oracle)?

Onlyplsql5 pointsBadges:

Cloning existing database servers to migrate to virtual machine

Can we clone existing database servers with their contents and migrate to a virtual machine? We want to do this for two smaller database servers that are each on very expensive high level machines. One can be repurposed and the other can support both servers as vms.

NewnanIT1,110 pointsBadges:

Excel date format

I am trying to copy data from one of our systems into Excel. Everything copies into Excel except the dates. My source data date format is MMM DD, YYYY (example Jul 14, 2004). I have tried changing the Excel from general to text and also tried changing the date formats.

Tamara5 pointsBadges:

Moving CA process in Domino 8.5

Hi, our usual Domino administrator has recently left the company and I’ve inherited the admin role due to the fact that I was once a domino admin myself. The only problem is that I was an admin under domino 5/6 and we’re now running 8.5 ! One of my first tasks was to decommission the domain...

Trappa015 pointsBadges:

Data Junction 7.0

I'm attempting to use Data Juntion to create a reference table (DB4)from a proprietary database to use as input to a reporting appliation.  I need to create between 1 and 12 output records from each qualifying record from my database.  Is this possible in Data Junction?   Thanks!

Gegrobe5 pointsBadges:

Transfer Data from one database to other.

Hi all, How to transfer datas from one database which has completelly different structure to other datebase with different structure? How to map these database? Is there any tool which does this? If so please suggest some free tool. Please help. Thank you all in advance.

4knowledgexchng20 pointsBadges:

Oracle 9i migration

How to migrate Oracle 9i from Windows 2000 server to Solaris and vice-versa?

OracleandSQLServer5 pointsBadges:

Bulk Insert with collation change

Hi, One of our client wants to change the collation of the database and the collation of the columns from SQL_Latin1_CP1_CS_AS to SQL_Latin1_CP1_CI_AS to match the SQL Server setting. So we are moving the data from one database to another database on the same server. We are re creating the database...

Db23290 pointsBadges:

Conversion of 32bit Informix to 64bit Informix

how to Convert 32bit informix to 64bit informix in hp-ux 11i

Rajuujar5 pointsBadges:

Finding which columns contain data in a table

I have to establish which columns in a table have data present. Each row has up to 100 columns, and not all of the columns contain data relating to the row. So in Table 1, Col1 Col2 Col3 Col4 Row 1 abc Row 2 abc Row 3 abc Would give a report showing that Table 1 has Columns Col1, Col2, Col4 being...

TedGiles5 pointsBadges:

Moving from Unix to Windows

We are contemplating moving our databases from the Unix platform to a Windows platform. The Windows servers we are thinking of purchasing are Itanium. We have been told that we can just copy the datafiles from the Unix platform to the Windows platform and everything should work fine. I am not so...

Manjit10 pointsBadges:

What constitute as System Migration?

I'm currently conducting a research on system migration (Learning Management System to be more specific) but it seems that most of the Whitepaper I've red talk about Legacy System migration and redeveloping the system. My company on the other hand, do not have developers to develop LMS instead we...

Iswan19710 pointsBadges:

SQL Database Migration Process

Hello, I would please like to know if someone could help me out with a database migration issue.I have a server and i need to migrate all of my data on my current database to a new database.It seems that the new database might be a little different in structure and the tables generally so i would...

Absorbed5 pointsBadges:

Oracle to SQL Server Migration – User Defined data types

Oracle database has two user defined types as the following: CREATE OR REPLACE type arrayType1 is table of int CREATE OR REPLACE type arrayType2 is table of varchar2(255) How do we represent these in SQL Server 2005?!! (Note: Microsoft SSMA fails to migrate these) Thanks

Kumar937825 pointsBadges:

Oracle to SQL Server Migration – CURSOR type conversion

When I migrated a small database from Oracle to SQL Server using Microsoft SSMA, it converted CURSOR types to varchar(8000) **SSMA Warning** O2SS0259:CURSOR type was converted to varchar(8000) ** Do we just leave this as is or does it require attention. Thanks.

Kumar937825 pointsBadges:

Move/Copy System DB’s to new server in SQL 2005

Trying to move system DB's to brand new server (really virtualized server). Server names are different. Any suggestions would be appreciated.

Seandon5 pointsBadges:

Migrate an Oracle database to SQL2005

I need to migrate an Oracle database to SQL2005. How many users have done this and what tool did you use? How effective was it? I know Microsoft has a migration tool, but just want to cover my bases as this is a very high profile project. Thanks all!!

mnman66265 pointsBadges: