>Haven't got that much experience with SQL server yet but VFP has a wizard that allows to upload your local data to the server. It doesn't seem to be 100 % bugfree, but it got me started. Have a look at it. In it's options it allows to define remote views of each local table and to keep the local tables under another name, 2 options I usually use ...
>I use micrsoft's Enterprise manager to manage the database itself. It came with a trial version of SQL7 server I downloaded (220mb!) a while ago ...

Upsizing Wizard, right? Cool, I'll try that, so I define my structures ect. in VFP, then aply them to MSDE/SQLServer, cool, thanks!