No announcements
Found 2227350 threads
-
1 Votesmigrate mainframe db2 data into sql server
It's an entire DB2 mainframe database, which consists of about 70 tables so I figured my approach would be one at a time to better isolate logical groupings of data.Answered | 7 Replies | 6185 Views | Created by Reppster - Thursday, January 7, 2010 7:35 PM | Last reply by Reppster - Friday, January 8, 2010 3:11 PM
-
1 Votes
Migration from DB2 to SQL Server
Hi, Currently, we don't have a SSMA migration tool for DB2.Answered | 3 Replies | 13443 Views | Created by Abhay_78 - Wednesday, November 10, 2010 6:20 PM | Last reply by Alex Feng (SQL) - Friday, November 12, 2010 8:27 AM -
1 Votes
Connecting to a IBM Mainframe Server, Not the Typical SQL Server
IBM mainframes typically host DB2.Answered | 2 Replies | 4477 Views | Created by encryptoras - Thursday, September 1, 2011 8:01 PM | Last reply by encryptoras - Friday, September 2, 2011 12:09 PM -
1 Votes
Migrating From DB2 to SQL using SSIS
you can , look at these links: http://www.bidn.com/blogs/PatrickLeBlanc/ssis/700/connecting-to-db2-using-ssisAnswered | 3 Replies | 10601 Views | Created by Abhay_78 - Thursday, November 11, 2010 2:40 PM | Last reply by Jinchun Chen - Monday, November 15, 2010 3:19 AM -
1 Votes
Mainframe modernization
Especially if it's a DB2 application.Answered | 1 Replies | 1030 Views | Created by Gabriela Dumencu - Friday, March 20, 2015 7:03 PM | Last reply by davidbaxterbrowne - Friday, March 20, 2015 8:02 PM -
0 Votes
SSMA for DB2 UDB (SQL Server Migration Assistance for DB2 UDB) - Migrate from DB2 UDB Version 10 to Sql server 2012
Hi Manuel, Could you please post the full error message when migrating DB2 database to SQL Server with SQL ...Answered | 1 Replies | 1720 Views | Created by Manuel Gato - Friday, August 28, 2015 11:10 AM | Last reply by Lydia Zhang - Monday, August 31, 2015 8:04 AM -
0 Votes
Migrate data error with DB2 Timestamp column
Hi Li Fan, Since SSMA 6.0 for DB2 cannot properly handle the DB2 timestamp column, I recommend you configure linked server between SQL ...Answered | 5 Replies | 2322 Views | Created by Li Fan - Monday, July 13, 2015 1:31 PM | Last reply by Lydia Zhang - Thursday, July 23, 2015 2:13 AM -
0 Votes
Reading Data from a Mainframe Mailbox
What I am looking for is how to read or transfer this file directly into a Sql Server table.Answered | 8 Replies | 1955 Views | Created by R_Abata - Tuesday, December 10, 2013 1:00 PM | Last reply by COZYROC - Wednesday, December 11, 2013 11:24 PM -
0 Votes
Creating Feeds for mainframe systems
Hi, I haven't tried it , but try below links , it will help you to some extent for sure ...Answered | 2 Replies | 2441 Views | Created by BLR_ETL - Friday, September 13, 2013 6:08 AM | Last reply by SathyanarrayananS - Friday, September 13, 2013 4:32 PM -
0 Votes
How can i Migrate a database from DB2 to SQL Server 2008r2.
Microsoft provide a migration assistant for DB2 to SQL Server:Answered | 1 Replies | 1540 Views | Created by Satish Reddy G - Thursday, March 26, 2015 12:25 PM | Last reply by jmcmullen - Thursday, March 26, 2015 12:50 PM -
0 Votes
MS SQL 2008 to IBM DB2 migration possible?
@SoftwareDeveloper83 If you migrate DB2 to SQL Server, I would suggest SSMA.Answered | 2 Replies | 6434 Views | Created by SoftwareDeveloper83 - Friday, April 13, 2012 12:57 PM | Last reply by Peja Tao - Monday, April 16, 2012 2:14 AM -
1 Votes
Problems with SSIS when transfering character data from Mainframe DB2 ebcedic to MSSQL 2012 unicode
But is quite easy to make the load happen by the means of a Transformation Script as described ...Answered | 2 Replies | 618 Views | Created by Hannis P. Wardum - Tuesday, March 15, 2016 9:54 AM | Last reply by Hannis P. Wardum - Tuesday, March 29, 2016 12:04 PM -
0 Votes
SSIS DB2-> SQL Server 2014 data migration issue (Timestamp -> DateTime2)
DATETIME2 in SQL Server or SSIS DT_DBTIMESTAMP2 so you need to make sure 1st you do not lose the last digits (if they are important).Answered | 3 Replies | 1846 Views | Created by asethura - Friday, March 25, 2016 3:15 PM | Last reply by ArthurZ - Friday, March 25, 2016 5:30 PM -
0 Votes
how we integrate java application data and mainframe data into ssis
http://sqlserverpedia.com/blog/sql-server-bloggers/etl-method-%E2%80%93-fastest-way-to-get-data-from-db2-to-microsoft-sql-serverAnswered | 6 Replies | 2638 Views | Created by Naresh_a - Wednesday, March 7, 2012 1:15 PM | Last reply by Raunak J - Wednesday, March 7, 2012 1:57 PM -
0 Votes
Migrate from Cognos10.2.1(db2) to SRSS(SQL Server)
So you might need to figure out what parts of your solution can realistically be migrated over.Answered | 4 Replies | 822 Views | Created by PB_SHS - Wednesday, March 4, 2015 11:23 AM | Last reply by PB_SHS - Wednesday, March 4, 2015 2:27 PM -
0 Votes
Migrate Db2 sabrix database to MSSQL
Another option is to use ConvertDB migration toolAnswered | 2 Replies | 3336 Views | Created by sehgalajay - Thursday, August 29, 2013 5:23 AM | Last reply by DMSoft - Friday, August 30, 2013 11:51 AM -
0 Votes
Bulk upload AS400/DB2 tables to SQL Server
Peja I see the DB2 Data Provider in SQL link, what are the parameters that I need to include in defenition of the link?Answered | 15 Replies | 10714 Views | Created by MHM281 - Friday, May 6, 2011 8:32 PM | Last reply by Peja Tao - Thursday, May 12, 2011 3:14 AM -
0 Votes
SSMA for DB2 z/OS: Extended Data Migration Options and timeout
Hi ririon, Firstly, do you run SQL Server Migration Assistant (SSMA) for DB2 onAnswered | 3 Replies | 2031 Views | Created by ririon - Tuesday, June 7, 2016 8:45 AM | Last reply by Lydia Zhang - Tuesday, June 14, 2016 12:06 PM -
0 Votes
Importing from Mainframe with Host Integration Server
Hi Shaheen24s, The following link will be helpful: Best Practices: Staging Mainframe/DB2 Data to SQL Server ...Answered | 16 Replies | 1770 Views | Created by Shaheen24s - Monday, October 21, 2019 4:51 PM | Last reply by Shaheen24s - Wednesday, October 30, 2019 1:11 PM -
0 Votes
Migrate to SQL Server
Well, it depends on the migration goals.Answered | 2 Replies | 873 Views | Created by Alberto J Prado - Tuesday, July 28, 2015 4:05 PM | Last reply by Stefan Hoffmann - Tuesday, July 28, 2015 4:17 PM - Items 1 to 20 of 2227350 Next ›
No announcements
