Database Migration

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.

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...

Oracle 9i migration

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

Conversion of 32bit Informix to 64bit Informix

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

How can we migrate Oracle database to Microsoft Access?

oracle to ms access

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 ...

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, plz help me.

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)?

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...

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.

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

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.

Moving a SQL database from one host to another

I need to help out in a move of a site coded in ASP/VBScript from one host we're having major problems with to another host that has been highly reliable for us. They both offer all the same features needed for this site, but we don't know how to move the SQL database along with the site. Can...

Data Migration Betrieve Tables to MS SQL Server 2005

Hi! could somebody help us advice on what to do and what to prepare if we are going to migration our current database Betrieve tables to MS SQL Server 2005? Thanks. Note: We are currently accessing the Betrieve tables thru PervasiveSQL v8 engine.

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!!

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...