Migration Tools

Can somebody suggest me migration tools for DB2 to SQL Server?
Thanks
Prashanttry this perhaps:

http://www.swissql.com/products/db2-to-sqlserver/db2-to-sql-server.html

Bill

Migration Tool

Can somebody suggest me migration tool for DB2 to SQL Server?
Thanks
Prashant
Prashant,
1. Create a linkedserver for DB2 - small quick migration
or
2. Use DTS (Data Transformation Services) - many tables
or
3. BCP (IN) - larger migration
or
4. Replication - depending on the needs
or
5. Third-party tool i.e.,
http://www.starquest.com/Productfolder/infoSQDR.html or
http://www.google.com/search?hl=en&l...&btnG =Search
HTH
Jerry
"Prashant Bharti" <prashantb@.aditi.com> wrote in message
news:uCaugHV2FHA.2472@.TK2MSFTNGP12.phx.gbl...
> Can somebody suggest me migration tool for DB2 to SQL Server?
> Thanks
> Prashant
>
|||Microsoft has plenty of information for migration from Oracle to MS SQL, but there
is nothing out there for DB2. What is the reason behind this, and will we soon see
a SSAM for DB2, as it already exists for Oracle ?
best regards
andreas
On Tue, 25 Oct 2005 08:26:56 -0700, "Jerry Spivey" <jspivey@.vestas-awt.com> wrote:

>Prashant,
>1. Create a linkedserver for DB2 - small quick migration
>or
>2. Use DTS (Data Transformation Services) - many tables
>or
>3. BCP (IN) - larger migration
>or
>4. Replication - depending on the needs
>or
>5. Third-party tool i.e.,
>http://www.starquest.com/Productfolder/infoSQDR.html or
>http://www.google.com/search?hl=en&l...&btnG =Search
>HTH
>Jerry
>"Prashant Bharti" <prashantb@.aditi.com> wrote in message
>news:uCaugHV2FHA.2472@.TK2MSFTNGP12.phx.gbl...
>

Migration Tool

Can somebody suggest me migration tool for DB2 to SQL Server?
Thanks
PrashantPrashant,
1. Create a linkedserver for DB2 - small quick migration
or
2. Use DTS (Data Transformation Services) - many tables
or
3. BCP (IN) - larger migration
or
4. Replication - depending on the needs
or
5. Third-party tool i.e.,
http://www.starquest.com/Productfolder/infoSQDR.html or
http://www.google.com/search?hl=en&lr=&q=migrate+db2+to+sql+server+&btnG=Search
HTH
Jerry
"Prashant Bharti" <prashantb@.aditi.com> wrote in message
news:uCaugHV2FHA.2472@.TK2MSFTNGP12.phx.gbl...
> Can somebody suggest me migration tool for DB2 to SQL Server?
> Thanks
> Prashant
>|||Microsoft has plenty of information for migration from Oracle to MS SQL, but there
is nothing out there for DB2. What is the reason behind this, and will we soon see
a SSAM for DB2, as it already exists for Oracle ?
best regards
andreas
On Tue, 25 Oct 2005 08:26:56 -0700, "Jerry Spivey" <jspivey@.vestas-awt.com> wrote:
>Prashant,
>1. Create a linkedserver for DB2 - small quick migration
>or
>2. Use DTS (Data Transformation Services) - many tables
>or
>3. BCP (IN) - larger migration
>or
>4. Replication - depending on the needs
>or
>5. Third-party tool i.e.,
>http://www.starquest.com/Productfolder/infoSQDR.html or
>http://www.google.com/search?hl=en&lr=&q=migrate+db2+to+sql+server+&btnG=Search
>HTH
>Jerry
>"Prashant Bharti" <prashantb@.aditi.com> wrote in message
>news:uCaugHV2FHA.2472@.TK2MSFTNGP12.phx.gbl...
>> Can somebody suggest me migration tool for DB2 to SQL Server?
>> Thanks
>> Prashant
>

Migration Tool

Can somebody suggest me migration tool for DB2 to SQL Server?
Thanks
PrashantPrashant,
1. Create a linkedserver for DB2 - small quick migration
or
2. Use DTS (Data Transformation Services) - many tables
or
3. BCP (IN) - larger migration
or
4. Replication - depending on the needs
or
5. Third-party tool i.e.,
http://www.starquest.com/Productfolder/infoSQDR.html or
[url]http://www.google.com/search?hl=en&lr=&q=migrate+db2+to+sql+server+&btnG=Search[/u
rl]
HTH
Jerry
"Prashant Bharti" <prashantb@.aditi.com> wrote in message
news:uCaugHV2FHA.2472@.TK2MSFTNGP12.phx.gbl...
> Can somebody suggest me migration tool for DB2 to SQL Server?
> Thanks
> Prashant
>|||Microsoft has plenty of information for migration from Oracle to MS SQL, but
there
is nothing out there for DB2. What is the reason behind this, and will we so
on see
a SSAM for DB2, as it already exists for Oracle ?
best regards
andreas
On Tue, 25 Oct 2005 08:26:56 -0700, "Jerry Spivey" <jspivey@.vestas-awt.com>
wrote:

>Prashant,
>1. Create a linkedserver for DB2 - small quick migration
>or
>2. Use DTS (Data Transformation Services) - many tables
>or
>3. BCP (IN) - larger migration
>or
>4. Replication - depending on the needs
>or
>5. Third-party tool i.e.,
>http://www.starquest.com/Productfolder/infoSQDR.html or
>[url]http://www.google.com/search?hl=en&lr=&q=migrate+db2+to+sql+server+&btnG=Search[/
url]
>HTH
>Jerry
>"Prashant Bharti" <prashantb@.aditi.com> wrote in message
>news:uCaugHV2FHA.2472@.TK2MSFTNGP12.phx.gbl...
>

Migration of Teradata and DB2 Timestamp fields.

I am trying to migrate timestamp fields in Teradata and
DB2 to SQL server. The problem is that Teradata and DB2
store timestamps to an accuracy of 1 microsecond, while
SQL Server stores it to the nearest 3.33 milliseconds
(the datetime datatype). The original accuracy needs to
be preserved as the columns are part of the primary key.
Is there an equivalent datatype in SQL Server or a quick
workaround for this problem? Date / Time functions need
to be performed on these columns.
There is no datatype in SQL Server that has a precision of 1 millisecond. I
can suggest 3 different workarounds:
- Store the timestamp in a CHAR(23) column in format
yyyy-mm-ddThh:mi:ss.nnn. You CONVERT this to and from datetime with style
126. Note that the precision will go back to 3.33 milliseconds when you
convert to datetime. This uses 23 bytes of storage.
- Store the timestamp as a UNIX timestamp (milliseconds since 1970-1-1) in a
BIGINT column. This uses 8 bytes of storage.
- Store the timestamp in 2 columns, one is a SMALLDATETIME (precision 1
minute), the second one is a INT, to store the number of milliseconds. This
uses 8 bytes of storage. (You can also use a SMALLINT if you want to save 2
bytes, but then you have to handle negative milliseconds.
Whichever is the most convenient of course depends on the calculations you
are going to do with it.
Jacco Schalkwijk
SQL Server MVP
"Arumugam" <arumugam@.optusnet.com.au> wrote in message
news:de3401c43bd6$5e60f870$a501280a@.phx.gbl...
> I am trying to migrate timestamp fields in Teradata and
> DB2 to SQL server. The problem is that Teradata and DB2
> store timestamps to an accuracy of 1 microsecond, while
> SQL Server stores it to the nearest 3.33 milliseconds
> (the datetime datatype). The original accuracy needs to
> be preserved as the columns are part of the primary key.
> Is there an equivalent datatype in SQL Server or a quick
> workaround for this problem? Date / Time functions need
> to be performed on these columns.

Migration of Teradata and DB2 Timestamp fields.

I am trying to migrate timestamp fields in Teradata and
DB2 to SQL server. The problem is that Teradata and DB2
store timestamps to an accuracy of 1 microsecond, while
SQL Server stores it to the nearest 3.33 milliseconds
(the datetime datatype). The original accuracy needs to
be preserved as the columns are part of the primary key.
Is there an equivalent datatype in SQL Server or a quick
workaround for this problem? Date / Time functions need
to be performed on these columns.There is no datatype in SQL Server that has a precision of 1 millisecond. I
can suggest 3 different workarounds:
- Store the timestamp in a CHAR(23) column in format
yyyy-mm-ddThh:mi:ss.nnn. You CONVERT this to and from datetime with style
126. Note that the precision will go back to 3.33 milliseconds when you
convert to datetime. This uses 23 bytes of storage.
- Store the timestamp as a UNIX timestamp (milliseconds since 1970-1-1) in a
BIGINT column. This uses 8 bytes of storage.
- Store the timestamp in 2 columns, one is a SMALLDATETIME (precision 1
minute), the second one is a INT, to store the number of milliseconds. This
uses 8 bytes of storage. (You can also use a SMALLINT if you want to save 2
bytes, but then you have to handle negative milliseconds.
Whichever is the most convenient of course depends on the calculations you
are going to do with it.
Jacco Schalkwijk
SQL Server MVP
"Arumugam" <arumugam@.optusnet.com.au> wrote in message
news:de3401c43bd6$5e60f870$a501280a@.phx.gbl...
> I am trying to migrate timestamp fields in Teradata and
> DB2 to SQL server. The problem is that Teradata and DB2
> store timestamps to an accuracy of 1 microsecond, while
> SQL Server stores it to the nearest 3.33 milliseconds
> (the datetime datatype). The original accuracy needs to
> be preserved as the columns are part of the primary key.
> Is there an equivalent datatype in SQL Server or a quick
> workaround for this problem? Date / Time functions need
> to be performed on these columns.

Migration of DB2 data to SQL 2005

Hello,

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

DB2 is running on AIX.

Thanks,

Herman

You should investigate using the DB2 driver available in the SQL Server Feature Pack.

http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/DB2OLEDB.exe

Donald

Migration of crystal reports from oracle to DB2

Crystal Reports is currently using Oracle. If the database is migrated to DB2 what are the changes required to be done for crystal reports to continue to work with DB2?
Can you please point me to relevant documentation?
TIA.Is it right to assume that the following changes are needed?

- Oracle driver to be replaced with appropriate DB2 driver
- SQL statements in crystal reports that use Oracle proprietary functions/features, join syntax, etc., to be replaced with corresponding / equivalent in DB2

Please let me have your input.

Thanks in advance.

Migration from DB2 to MSSQL Server 2000

Hi Friends,

I am doing my final semester project. It is a migration tool that converts the DB2 PL dialect into MSSQL Server's T-SQL dialect.
I am in need of sample DB2 PL files(procedures, UDFs, triggers) for testing the tool. Please point out me to some DB2 files repository links or if you have some files, please give me the same. I will use this only for testing purposes.

Appreciate your help.

Thanks & Regards,
JakeI suggest you place your request in DB2 threads too.|||Hi Protege,

Thanks for the suggestion. I have placed it in the DB2 thread also.

Thanks & Regards,
Jake

Originally posted by Protege
I suggest you place your request in DB2 threads too.

Migration from DB2

Hi,
We are migrating from DB2 to SQL Server 2000. We have used DB2 OLAP
functions (rank, sum, etc.) quit liberally. How should be translate them in
SQL Server.
Thanks
PrashantTake a look at SQL Server Analysis Services
http://www.microsoft.com/sql/evalua...bianalysis.mspx
http://sqlservercode.blogspot.com/
"Prashant Bharti" wrote:

> Hi,
> We are migrating from DB2 to SQL Server 2000. We have used DB2 OLAP
> functions (rank, sum, etc.) quit liberally. How should be translate them i
n
> SQL Server.
> Thanks
> Prashant
>
>|||I mean how can I translate following DB2 SQL to MS SQL Server SQL.
SELECT JOB, YEARS, ID, NAME,
ROW_NUMBER() OVER(PARTITION BY JOB ORDER BY YEARS) AS ROW#,
RANK() OVER(PARTITION BY JOB ORDER BY YEARS) AS RN1#,
DENSE_RANK() OVER(PARTITION BY JOB ORDER BY YEARS) AS RN2#
FROM STAFF
WHERE ID < 150 AND YEARS IN (6,7) AND JOB > 'L'
ORDER BY JOB, YEARS, ID, NAME
Thanks
Prashant
"SQL" <SQL@.discussions.microsoft.com> wrote in message
news:C1B8F525-56CC-419F-A731-AD70626DC169@.microsoft.com...
> Take a look at SQL Server Analysis Services
> http://www.microsoft.com/sql/evalua...bianalysis.mspx
> http://sqlservercode.blogspot.com/
>
> "Prashant Bharti" wrote:
>|||Use SQL Server 2005. It will be released in a few ws and has those constr
ucts.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Prashant Bharti" <prashantb@.aditi.com> wrote in message
news:uzB0lF%230FHA.3568@.TK2MSFTNGP15.phx.gbl...
>I mean how can I translate following DB2 SQL to MS SQL Server SQL.
> SELECT JOB, YEARS, ID, NAME,
> ROW_NUMBER() OVER(PARTITION BY JOB ORDER BY YEARS) AS ROW#,
> RANK() OVER(PARTITION BY JOB ORDER BY YEARS) AS RN1#,
> DENSE_RANK() OVER(PARTITION BY JOB ORDER BY YEARS) AS RN2#
> FROM STAFF
> WHERE ID < 150 AND YEARS IN (6,7) AND JOB > 'L'
> ORDER BY JOB, YEARS, ID, NAME
> Thanks
> Prashant
> "SQL" <SQL@.discussions.microsoft.com> wrote in message
> news:C1B8F525-56CC-419F-A731-AD70626DC169@.microsoft.com...
>|||Can you please send me any document/link which says that these will be in
SQL Server 2005.
Thanks
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:O25Vh$%230FHA.2072@.TK2MSFTNGP14.phx.gbl...
> Use SQL Server 2005. It will be released in a few ws and has those
> constructs.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Prashant Bharti" <prashantb@.aditi.com> wrote in message
> news:uzB0lF%230FHA.3568@.TK2MSFTNGP15.phx.gbl...
>|||You might be able to find the information at http://www.microsoft.com/sql/2005/def
ault.mspx. Or
download and install the documentation for 2005:
http://www.microsoft.com/downloads/...&displaylang=en
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Prashant Bharti" <prashantb@.aditi.com> wrote in message
news:u4Kl3Kk1FHA.980@.TK2MSFTNGP14.phx.gbl...
> Can you please send me any document/link which says that these will be in
SQL Server 2005.
> Thanks
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:O25Vh$%230FHA.2072@.TK2MSFTNGP14.phx.gbl...
>

migrating to ms sql from db2

currently running db2 database on IBM AS/400, looking to down size. We want to convert the db2 database to MS SQL and run it on windows 2003.
Is this a latteral move or do we have to change anything within DB2 or MS SQL(naming conventions, file types or sizes, schemas, etc) is there any tools out there for this type of migration?
Thank you for your help.You can reverse engineer your DB2 with ERwin and forward generate the model
to SQL to get your schema accross. But that is not necessarily a 1-button
push type operation. I imagine there will be subtle difference in how chars
and such are handled and they may manifest them selves as truncation bugs
and such when you run you stored procedures and such later.
Ata R
Parvan Consulting Inc
NO_SPAMar_alias001@.NO_SPAMparvan.net
"dossman10" <anonymous@.discussions.microsoft.com> wrote in message
news:F0CF5A34-6196-44D1-9FA7-4C086AD70BCF@.microsoft.com...
> currently running db2 database on IBM AS/400, looking to down size. We
want to convert the db2 database to MS SQL and run it on windows 2003.
> Is this a latteral move or do we have to change anything within DB2 or MS
SQL(naming conventions, file types or sizes, schemas, etc) is there any
tools out there for this type of migration?
> Thank you for your help.

migrating to ms sql

we are wanting convert to MS SQL and windows 2003 running on an Intel platfrom, converting from IBM DB2 AS/400. Is it possible and what would it take to convert
Thank you.Sure it's possible.
It will take time, money and resources. Resources should
include people knowledgeable of both DB2 and Sql Server.
Your question wasn't very specific, so it's hard to give
you a very good answer.
>--Original Message--
>we are wanting convert to MS SQL and windows 2003
running on an Intel platfrom, converting from IBM DB2
AS/400. Is it possible and what would it take to convert?
>Thank you.
>.
>|||"dossman10" <anonymous@.discussions.microsoft.com> wrote in message
news:D1D753CE-78FC-4553-A36E-14FE075CC5BA@.microsoft.com...
> we are wanting convert to MS SQL and windows 2003 running on an Intel
platfrom, converting from IBM DB2 AS/400. Is it possible and what would it
take to convert?
> Thank you.|||Hi,
If it is only tables, We can do the data transfer using DTS.
But to connect from Win2003 server to AS/400 machine you should install
DB2CONNECT for AS400 provided
by IBM.
Thanks
Hari
MCDBA
"dossman10" <anonymous@.discussions.microsoft.com> wrote in message
news:D1D753CE-78FC-4553-A36E-14FE075CC5BA@.microsoft.com...
> we are wanting convert to MS SQL and windows 2003 running on an Intel
platfrom, converting from IBM DB2 AS/400. Is it possible and what would it
take to convert?
> Thank you.