Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Migrating DB2 to SQL Server

Author  Topic 

kusonpadam
Starting Member

2 Posts

Posted - 2014-11-12 : 03:32:07
Does anyone have a recommendation for a program or anything that can script out an existing DB2 database (tables, SP's, functions...everything) in a format that is syntactically runnable in SQL Server? We need to migrate our DB2 database but there are a lot of objects and DDL and the normal scripting process does not compile (because of different syntax) in SQL Server. We can go through and change the script but it will take FOREVER and we are on a deadline. Would be great if there is a program that would do it for us.

http://thietkeweb.congay.com/thiet-ke-website-chuan-seo.html

grado
Starting Member

1 Post

Posted - 2014-11-17 : 04:07:32
try EMS SQL Manager. This software may fit what you need.

singapore seo std singapore
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-11-18 : 01:49:45
Is the DB2 database from a vendor? Does the vendor have alternative scripting for SQL Server?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -