Importing sql 2000 views into sql 2005

[BOA_Dev]

Its turning my views into tables! I just want to import it as a view. In the management studio I right click the database and select "Import data" and then I just follow the wizard. I have about 50 views so I really don't want to do this by hand! And for the life of me I can't figure out how to do this.

 

[BOA_Dev]

also, there doesnt seem to be an option to import stored procedures and DTS packages.

 

[Administrator]

You should be able to do this with SMO (SQL Management Objects)

 

[BOA_Dev]

so theres no wizards to do this huh? Well thanks for the help Ill have to look into Management Objects

 

[cjard]

A view is a select query that realises a result set. A view doesnt contain any data! If you "Import Data" from a view, then the query will be run, the data read and persisted as a table.

Try generating the Create Script for the view instead, and recreate the view from the script, not the data, in the new database..