Oracle's dynamic SQL to SQL Server

In my PLSQL to TSQL migration I need to convert dynamic SQL. Do I have direct conversion of statements like:

DBMS_SQL.PARSE
DBMS_SQL.BIND_VARIABLE
DBMS_SQL.DEFINE_COLUMN
DBMS_SQL.FETCH_ROWS
DBMS_SQL.PARSE

I need to maintain the code as similar as possible to the original one.

Thanks

here is a good start

http://technet.microsoft.com/en-us/library/bb497070.aspx

|||Dynamic SQL interfaces are much simpler in SQL Server. Start by looking at sp_executesql system stored procedure first. The migration link posted by Meher will also be useful.

Oracle to Sybase - Data Migration

Hi All,

I need to move data from some tables in oracle to sybase. Its jus kind of ad-hoc process - need to do it manually. I thought of doing it using DTS tool.

In sql server 2005 - using Integration Services - how to achieve this ? any help is greatly appreciated.

thanks.
Mani

It rather depends on the Sybase and Oracle connectivity that you have available. If you have the OLEDB drivers, then the import export wizard in SSIS should work for you. Right click on the SSIS packages node in an SSIS project in BI Dev Studio and select "SSIS Import and Export Wizard"

Donald

Oracle to SQLServer 2000 migration

Hi,

I need to migrate an Oracle database to SQLServer 2000 (tables, views, stored procedures, triggers, ...).

Can someone give me some good advice on how to do it properly?

I would appreciate for example a small list of steps to perform for doing this migration.

Thanks,
Isabel Sousa.try this

http://www.microsoft.com/sql/techinfo/deployment/2000/MigrateOracle.asp

You would probably want to take the opportunity to redesign though.

Oracle to SQL Server Migration using Server Migration Assistant for Oracle V2.0 - Help Needed

Hi all,

I am basically a front end guy and we need to do a dB migration from Oracle 9i to SQL Server (sitting in a shared environment).

For the start we wanna try out this tool. This tool provided by the MSN comes along with an extension pack that needs to be installed along with the tool.

http://www.microsoft.com/downloads/details.aspx?FamilyId=E35CEE88-C919-463F-B020-81468CD231DA&displaylang=en

It’s mentioned there that

Server component installation:
Locate a SQL Server machine which you want to migrate to. Run SSMAExtPack.exe on that machine locally.It will install a sysdb database with procedure and functions that emulate some of the Oracle system packages. You don't need to do anything on the server machine. All conversion tasks are done from the client SSMA tool.

Concern:

Since ours is a SQL server in a distributed environment it wont be possible for us to install the extension pack in all the systems that hosts the SQL server.

Queries

1) Is it necessary to install the extension pack in all the system our SQL Server is sitting?

or

2) Would it work if we install the tool in a separate system that holds the <extension pack+msn migration tool>, SQL Client and the Oracle client alone and complete the DB migration?

I need suggestion from the MSN tech support or anyone else with prior experiece whether its feasible to use the tool for our DB migration.

Note: Our Oracle DB contains only Tables and Indexes and there are no stored procedures. All the queries are dynamically built from the front end itself.

Sorry if I had posted this question in a wrong forum. I am new to this DB migration stuff.

If you cannot install the SQLpack on shared SQL, then you can try installing SSMAExtPack.exe on a client machine and create an empty database for the tables from Oracle, then arrange to port those tables back to shared SQL server.|||

Thanks Sathya for the suggestion..

So I reckon we need to create a DB on a stand alone SQL Server and transfer the tables and indexes from Oracle using the migration assistant.

From the standalone DB we need to transfer it to the shared environment. How do we migrate the tables from a standalone DB to the shared environment?

Can we use the SQL Server Data Transformation Services to migrate from temp SQL server DB to the shared environment or can you suggest any other tool provided by MSN you can suggest?

|||DTS is your friend in this case to transfer the data, but make sure to script out any triggers or SPs associated in this migration.

Oracle to SQL Server Migration using Server Migration Assistant for Oracle V2.0 - Help Neede

Hi all,

I am basically a front end guy and we need to do a dB migration from Oracle 9i to SQL Server (sitting in a shared environment).

For the start we wanna try out this tool. This tool provided by the MSN comes along with an extension pack that needs to be installed along with the tool.

http://www.microsoft.com/downloads/details.aspx?FamilyId=E35CEE88-C919-463F-B020-81468CD231DA&displaylang=en

It’s mentioned there that

Server component installation:
Locate a SQL Server machine which you want to migrate to. Run SSMAExtPack.exe on that machine locally.It will install a sysdb database with procedure and functions that emulate some of the Oracle system packages. You don't need to do anything on the server machine. All conversion tasks are done from the client SSMA tool.

Concern:

Since ours is a SQL server in a distributed environment it wont be possible for us to install the extension pack in all the systems that hosts the SQL server.

Queries

1) Is it necessary to install the extension pack in all the system our SQL Server is sitting?

or

2) Would it work if we install the tool in a separate system that holds the <extension pack+msn migration tool>, SQL Client and the Oracle client alone and complete the DB migration?

I need suggestion from the MSN tech support or anyone else with prior experiece whether its feasible to use the tool for our DB migration.

Note: Our Oracle DB contains only Tables and Indexes and there are no stored procedures. All the queries are dynamically built from the front end itself.

Sorry if I had posted this question in a wrong forum. I am new to this DB migration stuff.

If you cannot install the SQLpack on shared SQL, then you can try installing SSMAExtPack.exe on a client machine and create an empty database for the tables from Oracle, then arrange to port those tables back to shared SQL server.|||

Thanks Sathya for the suggestion..

So I reckon we need to create a DB on a stand alone SQL Server and transfer the tables and indexes from Oracle using the migration assistant.

From the standalone DB we need to transfer it to the shared environment. How do we migrate the tables from a standalone DB to the shared environment?

Can we use the SQL Server Data Transformation Services to migrate from temp SQL server DB to the shared environment or can you suggest any other tool provided by MSN you can suggest?

|||DTS is your friend in this case to transfer the data, but make sure to script out any triggers or SPs associated in this migration.

Oracle to SQL Server Migration

Hi,
We have an Oracle database with 3200 tables. We want to migrate this
database tables (both structure and data) to SQL Server 2005.
What would be the best way to do that? Is there any automated migration tool
for doing that?
Is there any white paper that explains Oracle to SQL Server migration paths?
Thank you,
MaxWhy don't you post this to Oracle ng's.Imo users of db's other than
MS have more experience with other dbs than do MS users.
"Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
news:ev2rw$LZGHA.1180@.TK2MSFTNGP03.phx.gbl...
> Hi,
>
> We have an Oracle database with 3200 tables. We want to migrate this
> database tables (both structure and data) to SQL Server 2005.
>
> What would be the best way to do that? Is there any automated migration
> tool for doing that?
>
> Is there any white paper that explains Oracle to SQL Server migration
> paths?
>
> Thank you,
> Max
>
>|||You can review several migration solutions.
SSMA is a free tool.
You can access blow url.
http://www.microsoft.com/sql/solutions/ssm/ssmav2.mspx
Also, you can search microsoft.com using keword "SwisSQL".
"Maxwell2006"?? ??? ??:

> Hi,
>
> We have an Oracle database with 3200 tables. We want to migrate this
> database tables (both structure and data) to SQL Server 2005.
>
> What would be the best way to do that? Is there any automated migration to
ol
> for doing that?
>
> Is there any white paper that explains Oracle to SQL Server migration path
s?
>
> Thank you,
> Max
>
>|||> Why don't you post this to Oracle ng's.Imo users of db's other than
> MS have more experience with other dbs than do MS users.
IMHO, Max is more likely to get more/better help here with the migration
task. It won't hurt to ping Oracle forums too but I believe there is more
experience here migrating from Oracle to SQL Server than you'll find in
Oracle forums.
Hope this helps.
Dan Guzman
SQL Server MVP
"Steve Dassin" <steve@.nospamrac4sql.net> wrote in message
news:%23HU9PHNZGHA.3752@.TK2MSFTNGP03.phx.gbl...
> Why don't you post this to Oracle ng's.Imo users of db's other than
> MS have more experience with other dbs than do MS users.
> "Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
> news:ev2rw$LZGHA.1180@.TK2MSFTNGP03.phx.gbl...
>|||In addition to hongju's response, check out
http://www.microsoft.com/technet/in...t.msp
x.
Hope this helps.
Dan Guzman
SQL Server MVP
"Maxwell2006" <alanalan@.newsgroup.nospam> wrote in message
news:ev2rw$LZGHA.1180@.TK2MSFTNGP03.phx.gbl...
> Hi,
>
> We have an Oracle database with 3200 tables. We want to migrate this
> database tables (both structure and data) to SQL Server 2005.
>
> What would be the best way to do that? Is there any automated migration
> tool for doing that?
>
> Is there any white paper that explains Oracle to SQL Server migration
> paths?
>
> Thank you,
> Max
>
>|||Ok where to find the devil as regards to 'the devil is in the details'.:)
www.rac4sql.net
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:uk2FVrNZGHA.1580@.TK2MSFTNGP02.phx.gbl...
> IMHO, Max is more likely to get more/better help here with the migration
> task. It won't hurt to ping Oracle forums too but I believe there is more
> experience here migrating from Oracle to SQL Server than you'll find in
> Oracle forums.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Steve Dassin" <steve@.nospamrac4sql.net> wrote in message
> news:%23HU9PHNZGHA.3752@.TK2MSFTNGP03.phx.gbl...
>|||Having done that several times, I' d like to warn you: that's a very
serious undertaking. IMHO existing tools will only get you that far.
Blocking/concurrency implemetation is enirely different, and there are
lots of other differences. I can give you dozens of scenarios when a
"ported" application raises no syntax errors but gives different
results and/or performs very poorly.
To make long story short, be ready to rewrite at least some of your
code.|||As far as blocking/concurrency is concerned, SQL Server 2005 supports
versioning based concurrency now. So migration should be a bit smoother than
in previous SQL Server versions.
Bob Beauchemin
http://www.SQLskills.com
"Alexander Kuznetsov" <AK_TIREDOFSPAM@.hotmail.COM> wrote in message
news:1145590726.530114.67950@.e56g2000cwe.googlegroups.com...
> Having done that several times, I' d like to warn you: that's a very
> serious undertaking. IMHO existing tools will only get you that far.
> Blocking/concurrency implemetation is enirely different, and there are
> lots of other differences. I can give you dozens of scenarios when a
> "ported" application raises no syntax errors but gives different
> results and/or performs very poorly.
> To make long story short, be ready to rewrite at least some of your
> code.
>|||I agree, whilst on the Ascend course last year, which was run by, errrrm,
BOB! (Hi Bob) my face lit up when he told, and demonstrated the Row
versioning functionality.
Some code changes may be unavoidable, but SQL2005 can work almost exactly
like Oracle, although this does cost a little in overall performance
(currently, it seems to be about .5%) If a program is developed on SQL
only, I'd not suggest using it, but in an oracle simulation mode, it will
save alot of hassle.
Back to the original question. There are tools around which will port schema
and datastructures. I've not had too much experience with these, but it
seems that these will need checking, not only that the structure of the new
tables are the equivilant, but that all the constraints have also been
copied. In short the tools will get you started, but I doubt that they can
be trusted to complete the job.
Regards
Colin Dawson
www.cjdawson.com
"Bob Beauchemin" <bobb_no_spam@.SQLskills.com> wrote in message
news:%23aCJOYQZGHA.4612@.TK2MSFTNGP03.phx.gbl...
> As far as blocking/concurrency is concerned, SQL Server 2005 supports
> versioning based concurrency now. So migration should be a bit smoother
> than in previous SQL Server versions.
> Bob Beauchemin
> http://www.SQLskills.com
> "Alexander Kuznetsov" <AK_TIREDOFSPAM@.hotmail.COM> wrote in message
> news:1145590726.530114.67950@.e56g2000cwe.googlegroups.com...
>|||Also refer http://www.akadia.com/services/sqlsrv2ora.html
Madhivanan

Oracle to Sql Migration

To all:
What are possible problems to watch out for before migrating Oracle server
to Sql Server?
Thanks for your anticipated response.
Davehi dave,
refer to following url
http://microsoft.com/sql/techinfo/deployment/2000/MigrateOracle.asp
--
Vishal Parkar
vgparkar@.yahoo.co.in|||Check out:
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/deploy/upgrdmigrate/sqlorcle.asp
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Dave" <Tunj@.hotmail.com> wrote in message
news:e1o8zci9DHA.2756@.TK2MSFTNGP10.phx.gbl...
> To all:
> What are possible problems to watch out for before migrating Oracle server
> to Sql Server?
> Thanks for your anticipated response.
> Dave
>

Oracle to Sql Migration

To all:
What are possible problems to watch out for before migrating Oracle server
to Sql Server?
Thanks for your anticipated response.
Davehi dave,
refer to following url
http://microsoft.com/sql/techinfo/d...grateOracle.asp
Vishal Parkar
vgparkar@.yahoo.co.in|||Check out:
http://www.microsoft.com/technet/tr...te/sqlorcle.asp
Hope this helps.
Dan Guzman
SQL Server MVP
"Dave" <Tunj@.hotmail.com> wrote in message
news:e1o8zci9DHA.2756@.TK2MSFTNGP10.phx.gbl...
> To all:
> What are possible problems to watch out for before migrating Oracle server
> to Sql Server?
> Thanks for your anticipated response.
> Dave
>

Oracle pl/sql and MSSQLserver

I have a solid experience in Oracle PL/SQL but now I am involved in a new migration project under MSSQLServer 2000 Database.
Anybody knows any documentation about sql programming in MSSQLServer to create my Stored Procedures, functions, Packages, tables and so on?I would start with the BOL Books on line which comes with SQL server. I am guessing you might not have it below is a link to where it can be downloaded.

http://www.microsoft.com/sql/techinfo/productdoc/2000/default.asp