Need Information On Data Migration

May 26, 2008



Hi all,

Hope your team will help me to resolve my problem.

I am working in a data migration project and need information on this work. I am having Multiple source database and my documents are stored in the ftp servers with the file path in my source database table.

I need to migrate these documents to my Destination FTP Servers , Migrate all the records to the destination database.

The source database are sybase(one) and SQL Server 2005(two)

Please provide me some links and your valuable comments to resolve this problem. To achieve this we have to use SSIS.
But i need more information to provide a clear picture in approach document.

What are the prerequisites to be analyzed for this migration work??

Please help me regarding this. Its really urgent for me!!

Regards,
Venkatesan Prabu . J

View 3 Replies


ADVERTISEMENT

SQL 2012 :: Data Validation Options After Data Migration From Sybase

Jun 24, 2014

I am currently in the process of migrating data from Sybase to Sql server and would like to know how to test the data migrated.

As of now, we took one table data from both source and destination and compared it in Excel to check if the data migrated looks good (note, we used SSIS to migrate data). However, I would like to check if there are any other best & easy ways to apprach data validation post migration.

View 3 Replies View Related

SQL 2012 :: Data Migration - Pull Data From All DBs To Input Into DW Table

Jul 15, 2014

I have a cluster hosting multiple GP databases and a second for my data-warehouse I am playing around with (personal project).

I have scripts that pull data from all the DB's to input into the DW's tables(Customers,Reps,Hub....)

An example of my branch script :

select interidas BranchID,
cmpnynamas BranchDesc,
address1as BranchAddressLine1,
address2as BranchAddressLine2,
address3as BranchAddressLine3,
zipcodeas PostalCode
from dynamics..SY01500

Where interid in ('comp1', 'comp2', 'comp4', 'comp5')

what would be the best way to using these scripts pull the data to my testDW and not have duplicate data issues?

I was thinking of using a staging DB on the GP cluster and then building an import data package to run nightly. the issue i had was how do i avoid duplicate data ?

View 0 Replies View Related

Data Migration Error - SQL TYPE Variant Data

Aug 21, 2006

I am trying to migrate our Portals database from SQL2000 to SQL2005, but I received "SQL Type Variant Data" error during the data migration with some database. Can anyone help me with this?

Thanks,

Jay

View 1 Replies View Related

Data Migration

Apr 20, 2000

I have data in tables with the constraints turn on.
I would like to remove all the data from the tables and add new data, and also reset the
identity back to 1, without dropping the constraints.

Any suggestions??

If I used truncate table, I would have to remove the primary key.
If I remove the primary key I would loss my constraints.

Thanks in advance,
Vic

View 2 Replies View Related

Data Migration

Sep 11, 2006

Dear All,

I'm having to manage data migration from a proprietary db system to an in-house designed sql server db.

Is there anyone out there who dealt with this and used software or services of companies specialising in this?

All ideas are welcome, thanks in advance!

View 3 Replies View Related

Data Migration

Jan 21, 2004

Hi
We are in the process of migrating Data from SQL SERVER 2000 to
Oracle 9i.

Can anyone let me know what are the steps that needs to be followed
in achieving the same.

If there's any specific documentation also available , please let me know
Any pointers would be of great help.

Thanks
Shankar Gokule

View 1 Replies View Related

Data Migration

May 31, 2007

I have 2 Tables



Table 1 has



Id

Type





Table 2 has



Id

Type

PartNumber



I need to migrate data from Table 1 to Table 2 based on Type.

Type can be 1 or 2.



Example of Source.



Table 1 has



Id Type

1 1

2 1

3 1

3 2



Table 2 should have 2 records for each Id and based on the Type have different Part Numbers. Part numbers will be the same if in the Source table I had just one record with type 1 and if I had 2 records with type 1 and 2 - Part number will be different.





Example of Destination.



Id Type PartNumber

1 1 10

1 2 10

2 1 11

2 2 11

3 1 12

3 2 13

================================

As you see above

1. I need to duplicate records which had just one type in the Source table.



1 1 10

1 2 10



I will have 2 (1 and 2) types now, but everything else the same for the same id.

In my case I will have Part Numbers as guid. I would create them on my own. They will be the same here.



2. I need to have 2 records as it was before in Source table for id's with 2 types, but with different Part Numbers.



3 1 12

3 2 13



In my case I will have Part Numbers as guid. I would create them on my own.They will be different here.





How do I create 2 records for each Id and certain rules for them? How do I find if there is one or there are two records in Source and how do I apply my rules in looping through records? What control in SSIS tool can I use?



Thanks.



View 8 Replies View Related

Data Mapping And Migration

May 28, 2004

Has anyone used DTS packages for migrating old data to a new schema?

If so are there any tutorials on this?

I'd prefer not to do this by hand. ;-)

View 3 Replies View Related

Data Migration Scripts

Oct 13, 2000

Hello,

I need a sql server 7 script that will migrate data from
my DEV dbase ON THE ALPHA SERVER to my WEB dbase ON THE BETA SERVER in a WINDOWS 2000 network. The data desired is for the field rig_id for rig number 0018. The shell of both dbases are similar.
The table is called rig. An snapshot is below:

DBASE name - DEV

TABLE name - rig

customer rig_id amount
Williams 0011 328
Borsha 0013 256
Kaila 0018 411
Yoida 0021 347

The rig table also exists on the WEB dbase. However, the Kaila data
for rig_id number 0018 needs to be added to the WEB dbase's rig table.
The Williams, Borsha, and Yoida data already exists on both tables.

I need to perform this migration w/ a TRANSACT-SQL stored procedure.

Thanks Very Much IN Advance,

Dave
gunnardl@yahoo.om

View 2 Replies View Related

Data Migration Issue (6.5 To 7.0)

Mar 7, 2001

Hello All ~

I have to migrate a database from 6.5 to 7.0 server. We don't have an upgrade wizard to i will have to do a turn around like :

> Scripting the objects
> Running the scripts in 7.0
> BCP out the data into 7.0.

But the problem lies here ! how do i BCP the whole database table data in one shot ? bcos i have a lot of tables in the database and i cannot afford to do a table at a time. If anyone has any script which creates pl do pass it on to me.

View 1 Replies View Related

Data Migration Tools

Jan 26, 1999

Hello Everyone,

Does anyone have experience in migrating data (not structure) from an Oracle 7.x database to a new schema built on SQL 6.5? Especially using third party migration tools, for example Data Junction 6.5?

I would be interested in seeing any materials you can provide or advise as I start down this path.

Thanks in advance,
Troy

View 1 Replies View Related

Data Migration, ID Problem

Jul 16, 2004

Hi all,

I'm working on the data migration section of my project at the moment. The customer I'm working for has an existing system of storing client information in an Excel file. Now, I want to move all this information into SQL Server so my new webapp can access the information. The problem is, for the client details, I used an ID system. For example, each piece of client information can be selected from a list. In the client table, this is stored as an ID. Then I have a ReferenceItem table where the IDs are mapped to descriptions. So my Client table has numbers in it, that map to descriptions in a different table.

Now, the existing Excel files have the descriptions, not IDs. What I need to do is to write some kind of script that will automatically go through the table created after I imported the Excel file, check each description and find it's ID and replace that description with the ID.

Now, I don't even know where to start on this one so if anyone has any pointers, could they please let me know?

Thanks
Eoin

View 1 Replies View Related

Data Migration From Excel

Feb 13, 2014

Please find the script for migration. Here I have attached two supporting documents. One is database diagram and the Excel sheet itself

USE [COONEW]
GO
/****** Object: StoredProcedure [dbo].[GetScheduledData] Script Date: 14/02/2014 10:35:29 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[GetScheduledData]

[Code] ....

View 2 Replies View Related

Data Migration With Value Replacement

Dec 16, 2006

Table A

200 Rows, each row: X, has a unique value. Has 2 extra columns: C1 and D1.

Table B

4000 Rows, each row: Z, has a value that corresponds to Table A's unique values. Has 2 extra columns: C2 and D2.

What I am looking to do is update all 4000 rows in Table B to match the data set in Table A. C1 -> C2, D1 -> D2 following the criteria that X = Z.

All the update attempts I've made so far only update 200 rows within Table B.

Thank you for your help.

View 1 Replies View Related

SSIS For Data Migration

Apr 5, 2007

Hi guys,

I just moved to SQL 2005 and am facing a difficulty trying to build a DTS Package using SSIS Projects. I need to migrate data from an old Database design to a new Database design in my local pc.

Can anyone provide me some guidelines or tutorials on which components to use and a flow of the entire process which I should follow? I am confused.

Thanks alot in advance, hope to hear from you guys soon.

View 1 Replies View Related

DATA STRUCTURE MIGRATION

Apr 23, 2008

Hi
Can Any one help me out of this in my project I have to migrate only datastructure or schema and not the data inside the table using SSIS. How can I do that ?

View 9 Replies View Related

Data Migration Overview Help

Jun 6, 2007

Hello,

This is my first project with SSIS and I'm having some problems migrating our current data import to it. Generally: right now we're pulling hourly data (which has a timestamp on it) in from a customer's db(which can't be modified, and is big and growing quickly) into our db. To do this we have been using a field to keep track of the last data download time (in our db) and then using that then when querying the customer's db to reduce the number of rows returned.

Will a similar system work in SSIS? I'm having trouble pulling the last download date out of the "target" database and using it in the query on the customer's db. Any advice on what I should be looking into to do this and am I headed in the right direction or just not thinking about this in a SSIS way?

How powerful/common are variables in SSIS and should I be trying to use them here?

Thanks,
Jeff

View 1 Replies View Related

Scribe Data Migration

Nov 16, 2007

hi friends,
i need help on scribe data updation and deletion i need to know what are all the steps to do for data updation on scribe data migration tool by using MS CRM adatapter.

and also i need to migrate data from crm to sql server i need scribe script for that migration

View 1 Replies View Related

Migration Of DB2 Data To SQL 2005

Jul 10, 2006

Hello,

What is the best option for migration of DB2 data to SQL 2005?

DB2 is running on AIX.

Thanks,

Herman





View 1 Replies View Related

Data Migration Using SSIS In SQL 2005

Aug 8, 2006

Greetings,
I am using SQL Server 2005 and I want a clue if there is some good built-in support to do the following.
I want to transfer all the data from one source database to another destination database having same number to tables and schema like source database. I also want to ensure that the old data on the destination database should be secure too.
I have an idea that this can be done through SSIS in coding but can anyone give me a guide, tip, link, sample code that can be helpful.
Thanx a million in advance.
Regards
 

View 1 Replies View Related

Data Migration Using Transactional Replication

Apr 12, 2007

I need to move my database servers from one location to another. The issue is that I have over 200 databases to move and my clients can't afford a downtime. The collective volume of all the databases is over 2.5 TB and growing.

I am thinking to copy these databases in batches over the WAN to the new location and replicate them using Transactional replication till I have all the databases moved and synchronized.

Will it be wise enough to use replication for synchronizing 200 databases or is there a better approach which I can use to move these databases with minimum downtime and compromise on performance of applications.

Note: Migration is from SQL Server 2000 to SQL Server 2005.

Thanks in advance.

Ritesh

View 1 Replies View Related

Data Mapping And Migration Tool?

Jun 21, 2014

I am developing one automation tool for data migration from one table to other table, here i am looking for one function or SP for which i will pass source column and destination column as input parameter and want output parameter to return true when source column data is compatible to copy to destination column if not then it should return false.

For example if source column is varchar and destination column is integer, the script should check all the data in source column in good enough to move to integer column or not and return the output flag. I want a script to work this for all types of data types.

View 2 Replies View Related

Data Migration Using Transactional Replication

Apr 12, 2007

I need to move my database servers from one location to another. The issue is that I have over 200 databases to move and my clients can't afford a downtime. The collective volume of all the databases is over 2.5 TB and growing.

I am thinking to copy these databases in batches over the WAN to the new location and replicate them using Transactional replication till I have all the databases moved and synchronized.

Will it be wise enough to use replication for synchronizing 200 databases or is there a better approach which I can use to move these databases with minimum downtime and compromise on performance of applications.


Note: Migration is from SQL Server 2000 to SQL Server 2005.


Thanks in advance.

Ritesh

View 1 Replies View Related

Data Migration From Sql 2000 To Sql 2005

Aug 28, 2007

hi. i am currently migrating data from sql server 2000 to sql server 2005 and i was wondering if any of you can help me. i found this tutorial

http://www.aspfree.com/c/a/MS-SQL-Server/Moving-Data-from-SQL-Server-2000-to-SQL-Server-2005/

and it seems really straight forward. does this tutorial cover everything i need to do for data migration? do i need to watch out for anything? if anyone knows of a better tutorial please let me know. thanks for the help.

View 6 Replies View Related

Help With Data Migration 2000 To 2005

Mar 7, 2008

Hi all. I'll say from the get go that I'm no SQL guru. I'm primarily a web dev who has been given the data jobs kind of by default so I'm definitely no DBA.

Anyway, having established my noobness, I have encountered an issue. The employer recently decided to upgrade our databases from 2000 to 2005 and I have been tasked to migrate the data from old to new. I have discovered the Import/Export Wizard and got it to move all the data in a dev database we use...but there was one problem. It seems that the tables in 2000 that had columns designated as identity columns do not have the identity attribute when they arrive in 2005.

I haven't figured a way to alter them to give them that attribute once they're in 2005 so I'm wondering if there's something I can do/change in the import process that would retain the identity property of the columns if I were to re-import them.

This is my first migration attempt so dumping it and starting over is no great loss...but any help would be most appreciated.

View 6 Replies View Related

SQL Server Data Migration And Synchronization

Apr 13, 2007



Hi,



I need to move my database servers from one location to another. The issue is that I have over 200 databases to move and my clients can't afford a downtime. The collective volume of all the databases is over 2.5 TB and growing.



I am thinking to copy these databases in batches over the WAN to the new location and replicate them using Transactional replication till I have all the databases moved and synchronized.



Will it be wise enough to use replication for synchronizing 200 databases or is there a better approach which I can use to move these databases with minimum downtime and compromise on performance of applications.



Note: Migration is from SQL Server 2000 to SQL Server 2005.



Thanks in advance.

Ritesh

View 9 Replies View Related

Looking For A Good Data Migration Solution

Oct 24, 2006

Hi,

I am trying to create a process that will take data source that has been output from a proprietary ISAM database to import into a SQL database. This particular ISAM system cannot be accessed via OleDB or ODBC. The thing is I want the process to be able to create the required tables based on data structure information that has been somehow encoded into the data source.

Currently the solution I am going with is to spit out a CSV file that has a header with table and data format information followed by rows of actual data that gets parsed by a SQL script however I am sure that Microsoft must have some kind of preferred solution to this kind of problem but I have not been able to find it. I have looked at the the tools that are available when creating a SQL Server DTS package as well as what seems to be available using the new Integration Services but nothing seems to be any better than the solution I just mentioned.

Anyone have any ideas, I am willing to bet there is a much better way of doing this.

View 2 Replies View Related

Data Migration MSDE -&&> SQL Compact

Feb 5, 2007

Hi all

Currently we are using the MSDE as SQL Server and decide to switch to use the smaller and file based SQL Server 2005 Compact Edition.

Because of update issue we need to merge data from an already installed database into the new compact edition. Are there some tools we could use in our installation routine (InstallShield) or are there some recommendations how we could do this data merging?

Thanks @ all
Daniel

View 3 Replies View Related

Need Tech Information About DTS On Data Warehousing

May 12, 2004

Hello, everone:

Anybody can offer technical information about DTS appied in data warehousing? Website, tutorial, forum and books will be great. Thanks.

ZYT

View 1 Replies View Related

Data Migration From MAIN FRAMES To SQL Server 200

Oct 19, 2001

What are the tools available in MS SQL Server 2000 migrate data from Main Frames. Can we do with DTS if so are drivers available to connect to sql servers.

Can you let me the technies and tools available ?

Thanks in Advance

View 2 Replies View Related

Data Conversion/Migration Tools/guide

Jun 11, 2008

Please point me towards some good trusted (possibly economical) Data Conversion tools for converting legacy system SQL 2000 (XML, Image all data type) db data to SQL 2005 database (and possibly to Oracle too) in a totally different db schema/structure.

View 6 Replies View Related

Change Collation- Migration Of Data Required

Jul 20, 2005

Hi,If I have a database with collation Sequence X and I change thecollation sequence of database to Collation Sequence Y , do I have tomigrate the data of tables with collation Sequence X to collationSequence Y or SQl server takes care of migrating the data internally.Thanks in advance.-Kalyan

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved