I think the OP at least owes us the work of taking these three solutions and determining which one is fastest.

So the vendor for the application is telling you that you have to migrate? Unless you have a highly customized version, I would assume they have done this migration...

Without the detail, it is really impossible to give you any time estimates. I think it will be big and expensive and ultimately end up costing more than it...

Other than creatively modifying the .css files for report manager, you have very little control over the look and feel of the web pages.

It is relatively easy to use the...

Jeff's article gives a bunch of options:

http://www.sqlservercentral.com/articles/TSQL/62867/%5B/url%5D

Here is one possible solution:

[font="Courier New"]-- no col1 col2 col3 col4 col5

-- 1 aaa bbb ccc null null

-- 2 vvv nnn null null null

/*

CREATE TABLE #tmpTest (GroupNum INT, Val VARCHAR(3))

INSERT...

Is there a reason you are not adding it to the calculations tab in BIDS?

The simplest solution will probably be to load the data into a table and then use a stored procedure to populate the child table.

Barring that, a lookup will handle the...

This is going to probably be a big job. Does the sybase database include a lot of stored procedures?

There are syntax differences that will take some time to resolve....

Yes.

The order is important.

Update the dimensions.

Incrementally add new records to the fact groups.

Process "Default" - this will rebuild any indexes or aggregations that the other two processes messed up.

Here are some pros:

1) Licensing - if they are on the same server, you only need one license.

2) Data does not need to be pulled over the network. If...

As far as I can tell, the best way is to keep the latest version in an integrated source control and do everything from BIDS.

You could just store the packages...

That is difficult to say.

Some people have had good luck with small multi-user environments using MS Access or an MS Access / SQL Server combination. I have typically found...

Do you understand that TIMESTAMP is not a date? It automatically changes every time an update is made to a record.

This is a data type that is used for...

When a dimension table is updated, you should only have to do a "Process Update" on the dimension. If you do this, your aggregations will be handled automatically on...