Backup and View question

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
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@.hotmail.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@.hotmail.com> wrote in message
> news:%23wGsBsASGHA.5156@.TK2MSFTNGP10.phx.gbl...
>
>

Backup and View question

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.
JasonThis is how the type of DTS wizard task you selected work. If you want the v
iews to be exported as
views, you need to use "Copy objects and data to SQL Server" task type in th
e Wizard.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jason Huang" <JasonHuang8888@.hotmail.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@.hotmail.com> wrote in message
> news:%23wGsBsASGHA.5156@.TK2MSFTNGP10.phx.gbl...
>
>

Backup and View question

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.
JasonThis 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@.hotmail.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@.hotmail.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
> >
>
>