|
Export and import of database views
Posted: 14 Feb 2006 07:08 PM |
Hello,
I have a database including many views. Some of them depend on other views.
Is anybody there who knows a method to export, import, copy all the views without trouble?
Using the DTS-Assistant or executing Stored Procedures failes. Many errors.
Are a database's views stored in a system table where I could copy them like "normal" datasets?
Thanks in advance.
Thomas |
|
|
 |
|
|
Re: Export and import of database views
Posted: 15 Feb 2006 10:56 AM |
Are you wanting to export the data in the views, or the structure of the views?
What process are you trying to use, and what errors are you getting?
I'm sure we can help - I'm just worried that we don't have sufficient information yet.
Rob |
|
|
|
|
|
Re: Export and import of database views
Posted: 15 Feb 2006 01:01 PM |
For SQL 2000, try this if you're trying to export the structure of the views..
declare @cr varchar(2)
select @cr = char(10) + char(13)
select text + @cr + 'GO' + @cr
from sysobjects so
join syscomments sc on so.id = sc.id
where objectproperty(so.id, 'IsView') = 1
and objectproperty(so.id, 'IsMSShipped') = 0
Cheers,
Greg Linwood
|
|
|
|
|