No announcements
Found 2960731 threads
-
1 VotesMigration from DB2 to SQL Server
Hi, Currently, we don't have a SSMA migration tool for DB2.Answered | 3 Replies | 13450 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
-
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 | 1723 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 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 | 829 Views | Created by PB_SHS - Wednesday, March 4, 2015 11:23 AM | Last reply by PB_SHS - Wednesday, March 4, 2015 2:27 PM -
1 Votes
migrate mainframe db2 data into sql server
The important thing to take from this conversation is just to find a provider that allows access to the particular DB2 environment in which your data is stored.Answered | 7 Replies | 6191 Views | Created by Reppster - Thursday, January 7, 2010 7:35 PM | Last reply by Reppster - Friday, January 8, 2010 3:11 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 | 1547 Views | Created by Satish Reddy G - Thursday, March 26, 2015 12:25 PM | Last reply by jmcmullen - Thursday, March 26, 2015 12:50 PM -
1 Votes
Migrating From DB2 to SQL using SSIS
There is a good guide MigrateDB2toSQLServer_2009.pdf from download.microsoft.com Arthur My BlogAnswered | 3 Replies | 10610 Views | Created by Abhay_78 - Thursday, November 11, 2010 2:40 PM | Last reply by Jinchun Chen - Monday, November 15, 2010 3:19 AM -
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 | 6440 Views | Created by SoftwareDeveloper83 - Friday, April 13, 2012 12:57 PM | Last reply by Peja Tao - Monday, April 16, 2012 2:14 AM -
0 Votes
Which version of SSMA supports migration from DB2 LUW v9.5 to SQL Server 2012?
Thanks Xi Jin it seems i need to figure out another way of migrating the DB2 LUW v9.5 to SQL Server 2012.Will check by using link server.Answered | 3 Replies | 1382 Views | Created by Karam55 - Wednesday, June 13, 2018 12:39 PM | Last reply by Karam55 - Friday, June 15, 2018 5:22 AM -
0 Votes
Migrate Db2 sabrix database to MSSQL
Another option is to use ConvertDB migration toolAnswered | 2 Replies | 3340 Views | Created by sehgalajay - Thursday, August 29, 2013 5:23 AM | Last reply by DMSoft - Friday, August 30, 2013 11:51 AM -
4 Votes
Urgent - Back Up from Db2 to Restore on SQL server
What you are wanting to do is real time replication from DB2 to SQL Server.Answered | 7 Replies | 3530 Views | Created by Zalak_Shah - Monday, March 25, 2013 9:39 AM | Last reply by scotdb - Tuesday, April 2, 2013 8:07 AM -
0 Votes
Bulk upload AS400/DB2 tables to SQL Server
Have you tried getting the data out from DB2 into a CSV file and then load that csv file to SQL Server ?Answered | 15 Replies | 10720 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
IBM DB2 to SQL 2012 migration using SSMA
[Generic: Mandatory] [9472/1] [2016-08-22 08:08:14]: SQL Server Migration Assistant for DB2 v7.0.0 [Generic: Mandatory] ...Answered | 2 Replies | 1907 Views | Created by J.A.Raper - Wednesday, August 10, 2016 4:12 PM | Last reply by justin raper - Monday, August 22, 2016 4:37 PM -
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 | 2328 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
Bulk Insert into DB2 from SQL Server 2005 Using Linked Server
The OLE DB Provider for DB2 is only available for the Enterprise and Developer Editions of SQL Server 2005.Answered | 11 Replies | 12010 Views | Created by jjkatz - Tuesday, March 8, 2011 2:51 PM | Last reply by Erland Sommarskog - Wednesday, March 9, 2011 10:31 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 | 1847 Views | Created by asethura - Friday, March 25, 2016 3:15 PM | Last reply by ArthurZ - Friday, March 25, 2016 5:30 PM -
1 Votes
Adding a DB2 database as a linked server in SQL 2000
Hi KLS, The error you are getting is from the DB2 server.Answered | 28 Replies | 21368 Views | Created by KLS130 - Wednesday, February 25, 2009 12:55 AM | Last reply by Prashant Kulkarni - Friday, May 21, 2010 8:15 PM -
0 Votes
DB2 and SSIS in SQL 2008
Download and specify what you need (for server you need the server edition of "connect" product).Answered | 10 Replies | 7613 Views | Created by JojoBinkus - Friday, November 11, 2011 3:15 PM | Last reply by COZYROC - Saturday, November 12, 2011 12:47 PM -
0 Votes
Migrating DB2 Embedded SQL for C/C++ (ESQL/C) to SQL Server 2012 - Pre-Compiler Needed.
Hi Team, In DB2 database, ("PREP") pre-compiler is used to convert ESQL/C (.sqc) to (.c) program.Answered | 4 Replies | 1791 Views | Created by Saravanan Kannivelan - Wednesday, May 10, 2017 2:48 PM | Last reply by Dave Patrick - Thursday, May 11, 2017 12:07 PM -
0 Votes
Import all objects(keys,indexes,etc.) into sql server from DB2 using SSIS
You will need your DB2 DBA script the objects, then convert the syntax into SQL Server syntax.Answered | 4 Replies | 2374 Views | Created by Sunil Chowdary - Monday, September 9, 2013 2:32 PM | Last reply by Tom Phillips - Monday, September 9, 2013 5:13 PM -
0 Votes
transferring data from SQL server 2008 to Db2/400 database
CozyRoc's DB2 Destination http://www.cozyroc.com/ssis/db2-destination.Answered | 2 Replies | 2918 Views | Created by cijojohn - Thursday, May 10, 2012 6:39 PM | Last reply by ArthurZ - Thursday, May 10, 2012 7:08 PM - Items 1 to 20 of 2960731 Next ›
No announcements
