DTS converting VIEWS into TABLES (sql2000) why?

[deeshubby]

I am creating a web application for my company's Intranet.

I have a SQL Server 2000 database, 10 TABLES, 17 VIEWS, 3 Stored Proc's., fairly simple, I suppose.

I'm trying to create a second, identical instance of this database on the server - that would serve as the information store that is used for admin people. So that ongoing UPDATES, DELETIONS and new INSERTS are happening on one instance, while basic

http://WWW service

is hitting the "static" instance.

When I run the DTS (right-click on DB >> All Tasks >> Export Data) all of my VIEWS are getting translated as TABLES in the new instance. That is, they are no longer "viewing" or "filtering" data from an orignal source table, but are rather coming across as stand-alone "hard-code" tables, now containing a literal snapshot of the information that the original views in the first DB instance would have displayed.

Any ideas what I'm doing wrong?
(I'm still somewhat of a newbie).

 

[jhall156]

Are you selecting copy all objects? JHall

 

[deeshubby]

I am selecting the 1st option of the 3 I am presented:
"Copy table and view from the source database"

Is this part of the problem?

 

[deeshubby]

don't know why those strikethrus are on my previous post... sorry...

I am selecting the 1st option of the 3 I am presented:
"Copy tables and views from the source database"

Is this part of the problem?

 

[jhall156]

I don't know, I've never used that option. I'd try the 3rd.
Incidentally, have you service packed your tools (i.e. for Enterprise Manager)? JHall

 

[deeshubby]

I probably do need to do the service pack update.

I tried to run the 3rd option:
Copy objects and data between SQL Server Databases

It begins to run the green progress bar for a while and appears to perform successfully up to a point. Then I get a 'failure to copy objects successfully'

If you click on the "red x" bullet next to the failed issue, it throws up my specific owner/role name (not the dbo user) as having already been created/existing on current database.

To backtrack a bit, should I be logged in as "dbo" for both instances of the databases?
When I run DTS, the "dbo" user/role & password is pre-populated in the fields for the "source db", and then I log on as myself - which I guess is a different owner/role, for the seconary, copied instance of the db which I'm wanting to create.

 

[jhall156]

Any systems administrator login would do I think.

But did you go to views and hit f5 to refresh the list in your target db? JHall