Migrate views to different server

A

Arno

Ha,

We've developed a couple of views (Analyze and Project Center) on the
development server and want to export them and then import them into
the testing environment.
Does anyone know a quick way to do this? I couldn't find any
documentation about it or anything in the SDK. Or is it just
rebuild?!?

Regards,

Arno
 
B

bill_murphy

I have used this utility and it works well. One hassel I had was one
of the parameters is the name of the SQL Server. I found that this was
a pain until I got on the the actual SQL box and then used the 'dot' as
the server name as in the following

viewback /b /n "file name to store the backup" /s . /d "project server
db name"

good luck
 
Top