MSDE - should i use filegroups

To allow for a proper migration path to SQL Server should i create my MSDE db
with FileGroups or can this be done later when migrating to SQL Server
without causing issues?
Can anyone recommend a best practice on what should be in each group?
tables (this can be broken further for large/small tables)
indexs
?
With a 2GB limit on data size I don't believe file groups would be needed.
You can create and remove file groups at any time if you migration path
requires it.
Jim
"Keeper" <Keeper@.discussions.microsoft.com> wrote in message
news:3B5BB1BC-E786-425F-AC9B-FB5778083927@.microsoft.com...
> To allow for a proper migration path to SQL Server should i create my MSDE
> db
> with FileGroups or can this be done later when migrating to SQL Server
> without causing issues?
> Can anyone recommend a best practice on what should be in each group?
> tables (this can be broken further for large/small tables)
> indexs
> ?
|||Since some clients will be msde and some sql server my company would like me
to keep things consistent. Can you point me in the right direction on how to
create the filegroups on msde.
I was thinking about just splitting up the indexes and tables at this point.
"Jim Young" wrote:

> With a 2GB limit on data size I don't believe file groups would be needed.
> You can create and remove file groups at any time if you migration path
> requires it.
> Jim
> "Keeper" <Keeper@.discussions.microsoft.com> wrote in message
> news:3B5BB1BC-E786-425F-AC9B-FB5778083927@.microsoft.com...
>
>