That was the hope.

What I'm seeing is that there are lots of changes necessary - index modifications, hints in the stored procedures that need changing, had to add sequences and...

If you go to File, New Project, then you should have various options, including database projects, business intelligence projects, etc. If you do not see these options, stick in...

Have you tried the steps in the article? I haven't tried with 2008 but I cannot imagine it would be much different.

Mikek - unfortunately it is not as simple as copy/paste. If you have visual studio you can just follow the directions in the article, and check out everyone's feedback...

Nice! Forgot about the ole log shipping. You can do a similar function with mirroring, but log shipping is probably a bit easier.

Actually you wouldn't even need to...

Good point Gail.

That's covered at this link jabba if you need it...

http://decipherinfosys.wordpress.com/2007/08/14/moving-tables-to-a-different-filegroup-in-sql-2005/

Again - it depends on the schema definition. A simple example that would reduce downtime.....a lot of simplistic assumptions are made here....

Say for instance that you have one particular...

With strict uptime requirements, this may get a little touchy. Here's a blog post that you may find helpful though. If it's one certain table(s) or index(es) that...

It sort of depends on your uptime requirements I guess. You can use backup & restore and use the WITH MOVE clause to move your files around. So...

I see nothing at all wrong with cool add-ons like this. In fact, in my message I mentioned that if he had the money, then he should definitely check...

I'm confused. Can you post an example of how you would like the data to look in its final stage?

Do you normally advertise on the forums like this?

sudheer_1185 - be aware that this commercial product is $500. If you have the money, looks pretty nice, but...

CozyRoc - is this free?

This should work.....You'll need to create two variables in the package corresponding to the variables referenced below (ZipFileName and ExtractionLocation). Also you will need to add a reference to...

Yes - I understand about striping tables across drives. Both of my scenarios allow for this, it's just that the striping occurs at different levels. In scenario #1,...