SQL Server Import / Export Views

[JPGStudios]

Hello.

I am having problems with exporting views from a remote database into a new database.

When I export the data to the new database it creates the views as tables.

I have looked through all the options and can't seem to get this right.

Does anyone know how to combat this?

Thanks.

Jason

[Dreamquick]

Hmm never seen that before.

Recreate them manually? After all a VIEW is only a glorified SELECT statement, once you know the statement content you know everything about that particular view.

- Tony

[JPGStudios]

I guess why I posted this is because I am not that good with SQL Server and I wasn't sure if there was any easier way to do it.

If I open and view and copy the SQL, then create a new view in my new database, it says that the SQL is incorrect, or it does not support the CASE SQL construct.

I am not sure what that means.

I can get all the tables, SP, and all the data out. I just can't get the views to transfer to the new DB.

Thanks.