That's what I was trying to say, "If we split the "business logic" into validity/integrity, common must-have business rules, application/work flow rules, and user specific rules, then the placement of...

I agree with Mike wholeheartedly. Forgive me if I came across the same way in my posts.

Sometimes we need to stir things up a bit to bring...

Well put, Everett.

One may ask whether or not it is good idea to put all the business logic in the application, when a company decides to move from a Java...

Because for years there has been one application and one database,

encapsulating the data validity and integrity rules in the application has worked successfully. There will continue to be opportunities...

jkli,

That's ok for small, static, narrowly targeted applications. That has been Microsoft's heritage and there will continue to be such applications.

However, Microsoft is targeting larger, more complex...

That script is very close to what I do with Oracle and SQL Server. I would make a simple change though. The two "CASE WHEN ISNULL()" should be...

Databases do scale and Microsoft would argue that they can scale as well as Oracle, but it takes skill to do this well. As Microsoft SQL Server has risen...

If the data is complex (lots of tables and columns) I would recommend a ETL tool like Pervasive's DataIntegrator (used to be DataJunction) or similar. These have good mapping...

If you are migrating just data, then set up a linked server and use scheduled jobs to migrate the data with DTS, as Hilary indicated.

I had to do homegrown replication...

I looked for any information on-line and could not find any. It's probably in Books Online for 2005.

(I have not loaded BOL for 2005 because I am not yet...

Scott's code is great, but I would suggest dumping the pure report content (details and aggregates) to a file and then use a separate program to process the data into...

And another thing...

If you really want formatted results, then use Business Objects' Crystal Reports or Microsoft Reporting Services.

These are much closer to Oracle Reports in functionality but with modern...

There are differences, but there are also many similarities. You might get similar results from using OSQL and the proper PRINT statements or even SELECT. Microsoft also has...

I have been doing dual development on Oracle and SQL Server for about three years now, usually starting with a good SQL*Plus script and then converting it to T-SQL and...

That really indicates an access control issue.

Are you sure that the job in the failover machine is owned or run by the SQL Agent account? It is...