QUESTION: Converting Oracle shell scripting from AIX to Windows

[DW]

Hi, all...

I have a sizeable database running under Oracle 9.2.0.4 under AIX
5.2.0.

I am faced with an impending move to a Windows environment, running
under SQL 2000.

Currently, we are heavy users of shell scripts, for exports, backups,
etc.

I am looking for viable scripting options under W2K/W2K3. Maybe sh/ksh
emulators, VB, Perl...?

Scheduling of script operations is also required.

Anyone been through this kind of move, who could offer some wisdom?
Thanks!
DW

[phil_herring]

DW wrote:

I am looking for viable scripting options under W2K/W2K3. Maybe sh/ksh
emulators, VB, Perl...?

www.cygwin.com

Shell, sed, grep, awk... everything you need, and free.
-- Phil

[fitzjarrell]

DW wrote:

Hi, all...

I have a sizeable database running under Oracle 9.2.0.4 under AIX
5.2.0.

I am faced with an impending move to a Windows environment, running
under SQL 2000.

Currently, we are heavy users of shell scripts, for exports, backups,
etc.

I am looking for viable scripting options under W2K/W2K3. Maybe sh/ksh
emulators, VB, Perl...?

Scheduling of script operations is also required.

Anyone been through this kind of move, who could offer some wisdom?
Thanks!
DW

If I read this correctly you're not only changing operating systems
(AIX to Windows 2000/2003 server) but DBMS engines as well (Oracle to
SQL Server 2000). What good will your Oracle-centric scripts be to SQL
Server? You'll need to get accustomed to SQL Server's Enterprise
Manager to schedule and execute tasks for which, using Oracle, you
could write shell scripts. And get used to backing up and truncating
transaction logs, using log shipping to synchronise backup/standby
servers, and you'll need to re-define the term 'database' as it isn't
the same as the definition to which you're currently acquainted.

Certainly you can download UNIX tools compiled to run under Windows,
including shells, and you may feel more comfortable doing so. However,
it's the Windows operating system upon which SQL Server depends; it may
behoove you to learn to write batch files in addition to transferring
your UNIX skills to Windows.

SQL Server 2000 is a far different beast than Oracle. I would
seriously reconsider your request for UNIX utilities for Windows, and
learn the operating system on which your new DBMS runs.
David Fitzjarrell

[David Portas]

DW wrote:

Hi, all...

I have a sizeable database running under Oracle 9.2.0.4 under AIX
5.2.0.

I am faced with an impending move to a Windows environment, running
under SQL 2000.

Currently, we are heavy users of shell scripts, for exports, backups,
etc.

I am looking for viable scripting options under W2K/W2K3. Maybe sh/ksh
emulators, VB, Perl...?

Scheduling of script operations is also required.

Anyone been through this kind of move, who could offer some wisdom?
Thanks!
DW

In SQL Server 2000 you can use Transact SQL scripts to perform the
operations you've mentioned (exporting and backing up data). You can
invoke Transact SQL from any of various scripting hosts using the OSQL
command line utility, using ODBC/OLEDB or other data access methods.
Windows scripting, VB script or DOS batch files are common choices for
straightforward tasks. For more complex logic you could consider .NET.

SQL Server comes with its own scheduler (SQL Agent) but you can also
use Windows or other third-party schedulers too.

SQL Server newsgroups in the microsoft hierarchy:

microsoft.public.sqlserver.server
microsoft.public.sqlserver.programming
etc

Hope this helps.

--
David Portas
SQL Server MVP
--

[Simon Hayes]

In addition to David Portas's comments, you might find the Oracle to
MSSQL migration white paper useful:

http://www.microsoft.com/resources/d...rt2/c0761.mspx

There is also a new Migration Assistant tool available:

http://www.microsoft.com/sql/migration/default.mspx

Simon

[Simon Hayes]

In addition to David Portas's comments, you might find the Oracle to
MSSQL migration white paper useful:

http://www.microsoft.com/resources/d...rt2/c0761.mspx

There is also a new Migration Assistant tool available:

http://www.microsoft.com/sql/migration/default.mspx

Simon

[DW]

"What good will your Oracle-centric scripts be to SQL Server?"

Exactly. I would like to retain the same functionality and flexibility
that I'm used to, and I'm really not convinced that such stuff can be
had in the limited confines of batch/cmd scripts.

Tx,

DW

[David Portas]

DW wrote:

"What good will your Oracle-centric scripts be to SQL Server?"

Exactly. I would like to retain the same functionality and flexibility
that I'm used to, and I'm really not convinced that such stuff can be
had in the limited confines of batch/cmd scripts.

Tx,

DW

Could you give an example of the sort of thing you need. Maybe we can
suggest a solution.

--
David Portas
SQL Server MVP
--

[DW]

Well, this is a project we will be engaged in over the next few months;
I'm sure I'll have many specific bits of functionality that I will have
challenges translating into different toolsets.

For now, my basic intent was to get some alternatives, which I can
research independently and see how they'll fit into our plans.

Once we begin a more granular assessment of the scripts that need to be
translated, I'll likely be back. ;-)

Thanks for the feedback!

[fitzjarrell]

DW wrote:

"What good will your Oracle-centric scripts be to SQL Server?"

Exactly. I would like to retain the same functionality and flexibility
that I'm used to, and I'm really not convinced that such stuff can be
had in the limited confines of batch/cmd scripts.

Tx,

DW

I would, were I you, download a copy of BOL (Books On-Line) from
www.microsoft.com/sql and start reading, as this is probably some of
the best information for SQL Server you'll find.

I would still learn the Enterprise Manager for SQL Server.
David Fitzjarrell

[Gerard H. Pille]

DW wrote:

Well, this is a project we will be engaged in over the next few months;
I'm sure I'll have many specific bits of functionality that I will have
challenges translating into different toolsets.

For now, my basic intent was to get some alternatives, which I can
research independently and see how they'll fit into our plans.

Once we begin a more granular assessment of the scripts that need to be
translated, I'll likely be back. ;-)

Thanks for the feedback!

In the mean time, let my offer you my sincere condoleances.

[DW]

"What good will your Oracle-centric scripts be to SQL Server?"

Exactly. I would like to retain the same functionality and flexibility
that I'm used to, and I'm really not convinced that such stuff can be
had in the limited confines of batch/cmd scripts.

Tx,

DW

[David Portas]

DW wrote:

"What good will your Oracle-centric scripts be to SQL Server?"

Exactly. I would like to retain the same functionality and flexibility
that I'm used to, and I'm really not convinced that such stuff can be
had in the limited confines of batch/cmd scripts.

Tx,

DW

Could you give an example of the sort of thing you need. Maybe we can
suggest a solution.

--
David Portas
SQL Server MVP
--

[DW]

Well, this is a project we will be engaged in over the next few months;
I'm sure I'll have many specific bits of functionality that I will have
challenges translating into different toolsets.

For now, my basic intent was to get some alternatives, which I can
research independently and see how they'll fit into our plans.

Once we begin a more granular assessment of the scripts that need to be
translated, I'll likely be back. ;-)

Thanks for the feedback!

[fitzjarrell]

DW wrote:

"What good will your Oracle-centric scripts be to SQL Server?"

Exactly. I would like to retain the same functionality and flexibility
that I'm used to, and I'm really not convinced that such stuff can be
had in the limited confines of batch/cmd scripts.

Tx,

DW

I would, were I you, download a copy of BOL (Books On-Line) from
www.microsoft.com/sql and start reading, as this is probably some of
the best information for SQL Server you'll find.

I would still learn the Enterprise Manager for SQL Server.
David Fitzjarrell

[Gerard H. Pille]

DW wrote:

Well, this is a project we will be engaged in over the next few months;
I'm sure I'll have many specific bits of functionality that I will have
challenges translating into different toolsets.

For now, my basic intent was to get some alternatives, which I can
research independently and see how they'll fit into our plans.

Once we begin a more granular assessment of the scripts that need to be
translated, I'll likely be back. ;-)

Thanks for the feedback!

In the mean time, let my offer you my sincere condoleances.

[DW]

Quite... ;-)

[DW]

Quite... ;-)

[Erland Sommarskog]

DW (dw*******@shaw.ca) writes:

I am looking for viable scripting options under W2K/W2K3. Maybe sh/ksh
emulators, VB, Perl...?

Perl is indeed available on Windows, see http://www.activestate.com for
a downloadable Perl binary for Windows.

As for connecting to SQL Server from Perl, this article on my web
site gives a quick overview of possible alterantives
http://www.sommarskog.se/mssqlperl/alternatives.html. Myself I offer two
modules in the area, but as they use DB-Library which is deprecated by
Microsoft, it's difficult to recommend them.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Erland Sommarskog]

DW (dw*******@shaw.ca) writes:

I am looking for viable scripting options under W2K/W2K3. Maybe sh/ksh
emulators, VB, Perl...?

Perl is indeed available on Windows, see http://www.activestate.com for
a downloadable Perl binary for Windows.

As for connecting to SQL Server from Perl, this article on my web
site gives a quick overview of possible alterantives
http://www.sommarskog.se/mssqlperl/alternatives.html. Myself I offer two
modules in the area, but as they use DB-Library which is deprecated by
Microsoft, it's difficult to recommend them.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp