Monday, 22 December 2014
     
AUSQLUG Forums Home   Search   Login   Register   Member List  
SQL Server 2000 Forums  > Data Transformation Services  > Export and import of database views  
 
Display using:  
Previous Thread :: Next Thread 
 Author Thread: Export and import of database views
tschroeder is not online. Last active: 10/03/2006 2:12:42 AM tschroeder
Top 50 Poster
Joined: 29 Jan 2006
Total Posts: 5
 
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
robf is not online. Last active: 10/06/2010 12:59:05 AM robf
msmvps.com
Top 25 Poster
Joined: 23 Feb 2005
Total Posts: 57
 
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
Greg_Linwood is not online. Last active: 20/07/2012 11:25:21 AM Greg_Linwood
www.sqlservants.com.au
Top 25 Poster
Forum Moderator
Joined: 07 Jun 2004
Total Posts: 123
 
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
Previous Thread :: Next Thread 
Page 1 of 1
 
AUSQLUG Forums  > SQL Server 2000 Forums  > Data Transformation Services  > Export and import of database views