Hi
I have a problem using SQL 2005 Export wizard.
I have 2 databases : DB1 and DB2
DB1 has X tables and Y views
DB2 has W tables and Z views
I want to export only few selected views from DB1 to DB2.
In Import and Export wizard, I select these views and execute the export-package. Completed Successfully.
And finally the problem:
All views that i exported from DB1, are not placed in DB2 as views, but as TABLES!
Why?
Waiting for your quick answer,
Martin
This is by design.
It may happen that some of the tables on which the view depends are not imported at all, which can cause the view definition to fail.
Thanks,
Kuntal
No comments:
Post a Comment