-
How can we migrate Oracle database to Microsoft Access?
How do I migrate an Oracle database to Microsoft Access?
-
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.
-
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...
Last updated: -
details about backup and recovery and suppose i was import data from oracle database. we can export to another database(not oracle)?
Last updated: -
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.
Last updated: -
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.
-
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...
Last updated: -
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!
Last updated: -
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.
Last updated: -
How to migrate Oracle 9i from Windows 2000 server to Solaris and vice-versa?
Last updated: -
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...
Last updated: -
Conversion of 32bit Informix to 64bit Informix
how to Convert 32bit informix to 64bit informix in hp-ux 11i
Last updated: -
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...
Last updated: -
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...
-
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...
Last updated: -
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...
Last updated: -
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
Last updated: -
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.
Last updated: -
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.
Last updated: -
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!!
Last updated: