Migration Tool

Can any one let me know the migration tool from Oracle to SQL Server ?
Thanks in advance.
Hi
Look at http://www.microsoft.com/sql/evaluat...are/oracle.asp
Regards
Mike
"John" wrote:

> Can any one let me know the migration tool from Oracle to SQL Server ?
> Thanks in advance.
>
>
|||SQLSwiss and DBBest. I, personally, like the DBBest product.
-Kev
~~~
-Kevin Kline
Quest Software (www.quest.com)
SQL Server MVP
I support PASS, the Professional Association for SQL Server. (www.sqlpass.org)

> Can any one let me know the migration tool from Oracle to SQL Server ?
> Thanks in advance.
>
|||try SwisSQL (http://swissql.com/).
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||FastReaser is probably the best for moving large volumes of data from
Oracle to SQL Server which is very important during export data from large
and heavy production Oracle database. Fastreader is from Wisdomforce:
www.wisdomforce.com
John
Message posted via http://www.sqlmonster.com

Migration Tool

What is the best tool for migrating the database from access to SQL Server
or vise versa.
Thanks
Hi
Look at http://support.microsoft.com/default...b;en-us;237980 for
information.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"John" <naissani@.hotmail.com> wrote in message
news:eluyvpFEFHA.1396@.tk2msftngp13.phx.gbl...
> What is the best tool for migrating the database from access to SQL Server
> or vise versa.
> Thanks
>

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 to ms-sql

Hi,
Does any one aware of any tool for sybase to ms-sql migration, which will migrate store procedures/triggers from sybase to ms-sql server 2000.
Thanks
Vaishalinever done it, some googling came out with many results
sqlporter (http://www.realsoftstudio.com/overview.php) sounds impressive though. :cool:|||Hi Vaishali,

I came across the Migration tool that which doing fine in database migration. Which u needs fulfill the requirement. Yes. Plz. visit the www.swissql.com.

Regards
Saravanan.R|||Thanks Saravanan & Harshal!
Saravanan,
Does it migrate all the objects without any problem. I have visited this site. Is there a trial version available for this. I could not get any.

Migration of SQL Server 2000 db to Oracle 9i

Hi,
Can anyone let me know of a tool which shall migrate the entire SQL Server
2000 database to Oracle 9i along with all the stored procedures . Someone in
the net has posted that a tool comes with the Oracle 9i software .
Any help would be appreciated .
Thanks ,
Sujay
Sujay Ghosh
Bangalore, INDIA
Email : sujayg_mfc@.yahoo.com
Mobile : 9845467789
Such migrations are difficult, since the two systems don't port well to
each. Why are you migrating to Oracle? SQL Server performs just as well,
is easier to use and costs less.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Sujay Ghosh" <sujayg_mfc@.yahoo.com> wrote in message
news:8FBE768D-AE03-429A-98F0-951A28614C3E@.microsoft.com...
Hi,
Can anyone let me know of a tool which shall migrate the entire SQL Server
2000 database to Oracle 9i along with all the stored procedures . Someone
in
the net has posted that a tool comes with the Oracle 9i software .
Any help would be appreciated .
Thanks ,
Sujay
Sujay Ghosh
Bangalore, INDIA
Email : sujayg_mfc@.yahoo.com
Mobile : 9845467789
|||Hi Tom ,
I am working on a product which shall support both SQL Server 2000 and
Oracle 9i. Now the product is working fine with SQL Server 2000 , but when I
am working on the same product with the back end as Oracle 9i to test the
app, I need to do the migration , because there are some changes in Oracle
stored procedures which are not similar to that of SQL Server 2000 .
Please let me know how can it be solved .
Thanks ,
Sujay
"Tom Moreau" wrote:

> Such migrations are difficult, since the two systems don't port well to
> each. Why are you migrating to Oracle? SQL Server performs just as well,
> is easier to use and costs less.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> ..
> "Sujay Ghosh" <sujayg_mfc@.yahoo.com> wrote in message
> news:8FBE768D-AE03-429A-98F0-951A28614C3E@.microsoft.com...
> Hi,
> Can anyone let me know of a tool which shall migrate the entire SQL Server
> 2000 database to Oracle 9i along with all the stored procedures . Someone
> in
> the net has posted that a tool comes with the Oracle 9i software .
> Any help would be appreciated .
> Thanks ,
> Sujay
> --
> Sujay Ghosh
> Bangalore, INDIA
> Email : sujayg_mfc@.yahoo.com
> Mobile : 9845467789
>
|||Well, it won't be easy. Oracle's dialect of SQL is not the same as SQL
Server's. For example, where you would use DECODE in Oracle, you'd use CASE
in SQL Server. FWIW, MS is coming out with a migration tool to go from
Oracle to SQL Server but not the other way.
Good luck.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Sujay Ghosh" <sujayg_mfc@.yahoo.com> wrote in message
news:87EED46A-8510-4F71-A7C9-8107B7390532@.microsoft.com...
Hi Tom ,
I am working on a product which shall support both SQL Server 2000 and
Oracle 9i. Now the product is working fine with SQL Server 2000 , but when I
am working on the same product with the back end as Oracle 9i to test the
app, I need to do the migration , because there are some changes in Oracle
stored procedures which are not similar to that of SQL Server 2000 .
Please let me know how can it be solved .
Thanks ,
Sujay
"Tom Moreau" wrote:

> Such migrations are difficult, since the two systems don't port well to
> each. Why are you migrating to Oracle? SQL Server performs just as well,
> is easier to use and costs less.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> ..
> "Sujay Ghosh" <sujayg_mfc@.yahoo.com> wrote in message
> news:8FBE768D-AE03-429A-98F0-951A28614C3E@.microsoft.com...
> Hi,
> Can anyone let me know of a tool which shall migrate the entire SQL
> Server
> 2000 database to Oracle 9i along with all the stored procedures . Someone
> in
> the net has posted that a tool comes with the Oracle 9i software .
> Any help would be appreciated .
> Thanks ,
> Sujay
> --
> Sujay Ghosh
> Bangalore, INDIA
> Email : sujayg_mfc@.yahoo.com
> Mobile : 9845467789
>
|||The tool that was mentioned could have been Oracle Migration
Workbench. It doesn't always work too well and the code that
is generated is a bit of a mess.
But you can find info and a download link at:
http://www.oracle.com/technology/tec...nch/index.html
-Sue
On Sun, 13 Mar 2005 01:35:03 -0800, "Sujay Ghosh"
<sujayg_mfc@.yahoo.com> wrote:
[vbcol=seagreen]
>Hi Tom ,
> I am working on a product which shall support both SQL Server 2000 and
>Oracle 9i. Now the product is working fine with SQL Server 2000 , but when I
>am working on the same product with the back end as Oracle 9i to test the
>app, I need to do the migration , because there are some changes in Oracle
>stored procedures which are not similar to that of SQL Server 2000 .
> Please let me know how can it be solved .
> Thanks ,
>Sujay
>
>"Tom Moreau" wrote:

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.