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:
Showing posts with label along. Show all posts
Showing posts with label along. Show all posts
Friday, March 9, 2012
Migration Of MSSQL instance along with security permissions
Hi All,
This is the scenario. Basically i work for a web hosting company now we have taken over control of a competitor and would like to migrate there existing data to our own MSSQL server's in order to integrate them into our automatic system etc etc ...
The current system is running MSSQL7.
The system been copied to is MSSQL2K.
Objectives:
Retain all security accounts listed on the MSSQL7 system and use them on the MSSQL2K system. This includes all the logins that use standard MSSQL login's. (Reason : To ensure that all the customers ASP pages work after the DB's have been copied.)
Backup all the databases on the MSSQL7 and restore them to the MSSQL2K system. Unfortunately system is running on a different network with firewall's etc in between. What type of maintenance plan and how should i implement the requirement to keep all the login account's?
Any help greatly appreciated......
thxone of the option can be like take all backups on either hdd or tape then connect it to ur server copy it from previous one to new one.
to copy all login info etc u can write a script if u need the script i can send u next time (this will take the info to a cursor and one by one it wil update.)
as far as sql 7 database schema and 2k schema is concerned i dont think it will be a problem.
this is an intersting case pl update me|||Hi ranjan apologies for not replying sooner (did not know if anyone had replied). I agree when u state that u dont think either that the difference between porting to 2000 is going to cause an issue. I have restored all the databases now but am in need of a little help / inspiration on how to port over the login names. Perhaps you can help or have a script that performs this task. Regards the script u have for updating i presume its independent to the current logins that are on the SQL2K system at present. How is this done?
This is the scenario. Basically i work for a web hosting company now we have taken over control of a competitor and would like to migrate there existing data to our own MSSQL server's in order to integrate them into our automatic system etc etc ...
The current system is running MSSQL7.
The system been copied to is MSSQL2K.
Objectives:
Retain all security accounts listed on the MSSQL7 system and use them on the MSSQL2K system. This includes all the logins that use standard MSSQL login's. (Reason : To ensure that all the customers ASP pages work after the DB's have been copied.)
Backup all the databases on the MSSQL7 and restore them to the MSSQL2K system. Unfortunately system is running on a different network with firewall's etc in between. What type of maintenance plan and how should i implement the requirement to keep all the login account's?
Any help greatly appreciated......
thxone of the option can be like take all backups on either hdd or tape then connect it to ur server copy it from previous one to new one.
to copy all login info etc u can write a script if u need the script i can send u next time (this will take the info to a cursor and one by one it wil update.)
as far as sql 7 database schema and 2k schema is concerned i dont think it will be a problem.
this is an intersting case pl update me|||Hi ranjan apologies for not replying sooner (did not know if anyone had replied). I agree when u state that u dont think either that the difference between porting to 2000 is going to cause an issue. I have restored all the databases now but am in need of a little help / inspiration on how to port over the login names. Perhaps you can help or have a script that performs this task. Regards the script u have for updating i presume its independent to the current logins that are on the SQL2K system at present. How is this done?
Subscribe to:
Posts (Atom)