|
Home > Archive > MS SQL Server > March 2006 > Backup and View question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Backup and View question
|
|
| Jason Huang 2006-03-15, 3:23 am |
| Hi,
I export my DatabaseA into a brand new DatabaseB, using DTS Import/Export
Wizard.
I have some Views in the DatabaseA.
However, those Views in DatabaseA became Tables in DatabaseB, not Views.
But what I want is View, not Table.
Would someone tell me how to fix this problem?
Thanks for help.
Jason
| |
| Tibor Karaszi 2006-03-15, 3:23 am |
| This is how the type of DTS wizard task you selected work. If you want the views to be exported as
views, you need to use "Copy objects and data to SQL Server" task type in the Wizard.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"Jason Huang" < JasonHuang8888@hotma
il.com> wrote in message
news:%23wGsBsASGHA.5156@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> I export my DatabaseA into a brand new DatabaseB, using DTS Import/Export Wizard.
> I have some Views in the DatabaseA.
> However, those Views in DatabaseA became Tables in DatabaseB, not Views.
> But what I want is View, not Table.
> Would someone tell me how to fix this problem?
> Thanks for help.
>
>
> Jason
>
| |
|
| Also you would avoid select them (within import-export wizard) and then
generate them scripts separately.
--
current location: alicante (es)
"Tibor Karaszi" wrote:
> This is how the type of DTS wizard task you selected work. If you want the views to be exported as
> views, you need to use "Copy objects and data to SQL Server" task type in the Wizard.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
>
>
> "Jason Huang" < JasonHuang8888@hotma
il.com> wrote in message
> news:%23wGsBsASGHA.5156@TK2MSFTNGP10.phx.gbl...
>
>
>
|
|
|
|
|