I'm setting up a dev/test server for a couple of websites that use several databases. Do to cost our dev/test server is actually a WinXP-SP2 machine.

When I try to import the current data from MSSQL on one server to the dev/test server I cannot do it because the dev/test server isn't a true server. Without the data, a dev/test environment is useless.

I'm pretty much a newbie to SQL Server management (I've done plenty w/ SQL) is there something I'm missing or am I just unable to accomplish this?

TIA

What do you mean its not a true database server? Did you install the MSDE? In any case you should be able to back up the databases, move them to the XP box and restore them. Did you install Enterprise Manager on the XP box?

What do you mean its not a true database server?
I should have said that when I went to import I was able to say which server I wanted to import from, but I was not able to identify a server to import too.

Did you install the MSDE? In any case you should be able to back up the databases, move them to the XP box and restore them. Did you install Enterprise Manager on the XP box?

I have installed the Enterprise Manager, but not the Developer Edition. I did find the SQL Group that was on the other server and "registered" it (I think that is the right terminology), however I see that it gives me real-time data and that isn't want I want. Of course right now I'm in the "crap, do I delete that group on the dev/test server? And if I do, will I blow up the data on both ends?"

Tinkering is good... sometimes. ;)

Thanks rstelma

Yeah, the only SQL version that you can install on XP is the developer edition.

Once you do that you'll be able to register the server in EM on the XP box and be able to import directly from the other server.

Cool - I'll work that first thing in the morning.

Thanks rstelma