Howdo I move mssql databases?

[AbsolutelyFreeW]

I would like to move them from one server to another...

In mysql, I would simply script the database with phpmyadmin.

How do I do it with the mssql (actually msde) databases? is it possible just scripting it with the built in asp enterprise?

any other ideas?

 

[JonRohan]

Im not sure if that is possible. You need the full MS SQL product with the real enterprise manager on it in order to move / save databases.

 

[AbsolutelyFreeW]

I found a program that helps, query transformer from sqlland.. however their site seems to be down now www.sqlland.com