Importing Data into SQL 2005

I tried to import a table from SQL 2000 server to SQL 2005 server. Between
SQL 2000 servers I can choose to drop the current table if it exists at
destination. However in SQL Server Management Studio there is no option to
drop the existing table. Do I miss something here? How do you guys import
in this case? Thanks.It gets worse. The "object transfer" component doesn't take indexes,
identity properties, constraints or pretty much anything except the raw
table structure. DTS was a good data migration utility and a decent ETL
platform. SSIS is a great ETL tool and a poor data migration tool.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"ME" <ME@.mail.com> wrote in message
news:ONJ1$SwGHHA.3540@.TK2MSFTNGP02.phx.gbl...
>I tried to import a table from SQL 2000 server to SQL 2005 server. Between
>SQL 2000 servers I can choose to drop the current table if it exists at
>destination. However in SQL Server Management Studio there is no option to
>drop the existing table. Do I miss something here? How do you guys import
>in this case? Thanks.
>|||You are correct.
now it comes to fun part: to create SSIS package I must purchase license for
Visual Studio?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23r$SwowGHHA.1264@.TK2MSFTNGP03.phx.gbl...
> It gets worse. The "object transfer" component doesn't take indexes,
> identity properties, constraints or pretty much anything except the raw
> table structure. DTS was a good data migration utility and a decent ETL
> platform. SSIS is a great ETL tool and a poor data migration tool.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "ME" <ME@.mail.com> wrote in message
> news:ONJ1$SwGHHA.3540@.TK2MSFTNGP02.phx.gbl...
>>I tried to import a table from SQL 2000 server to SQL 2005 server.
>>Between SQL 2000 servers I can choose to drop the current table if it
>>exists at destination. However in SQL Server Management Studio there is
>>no option to drop the existing table. Do I miss something here? How do
>>you guys import in this case? Thanks.
>|||SQL Server 2005 Developer edition is $50 and includes the BI workbench.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"ME" <ME@.mail.com> wrote in message
news:u0yaw2wGHHA.4904@.TK2MSFTNGP04.phx.gbl...
> You are correct.
> now it comes to fun part: to create SSIS package I must purchase license
> for Visual Studio?
>
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:%23r$SwowGHHA.1264@.TK2MSFTNGP03.phx.gbl...
>> It gets worse. The "object transfer" component doesn't take indexes,
>> identity properties, constraints or pretty much anything except the raw
>> table structure. DTS was a good data migration utility and a decent ETL
>> platform. SSIS is a great ETL tool and a poor data migration tool.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>>
>> "ME" <ME@.mail.com> wrote in message
>> news:ONJ1$SwGHHA.3540@.TK2MSFTNGP02.phx.gbl...
>>I tried to import a table from SQL 2000 server to SQL 2005 server.
>>Between SQL 2000 servers I can choose to drop the current table if it
>>exists at destination. However in SQL Server Management Studio there is
>>no option to drop the existing table. Do I miss something here? How do
>>you guys import in this case? Thanks.
>>
>|||> now it comes to fun part: to create SSIS package I must purchase license for Visual Studio?
No, the Visual Studio IDE is shipped with SQL Server. It is called Business Intelligence Development
Studio.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ME" <ME@.mail.com> wrote in message news:u0yaw2wGHHA.4904@.TK2MSFTNGP04.phx.gbl...
> You are correct.
> now it comes to fun part: to create SSIS package I must purchase license for Visual Studio?
>
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:%23r$SwowGHHA.1264@.TK2MSFTNGP03.phx.gbl...
>> It gets worse. The "object transfer" component doesn't take indexes, identity properties,
>> constraints or pretty much anything except the raw table structure. DTS was a good data
>> migration utility and a decent ETL platform. SSIS is a great ETL tool and a poor data migration
>> tool.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>>
>> "ME" <ME@.mail.com> wrote in message news:ONJ1$SwGHHA.3540@.TK2MSFTNGP02.phx.gbl...
>>I tried to import a table from SQL 2000 server to SQL 2005 server. Between SQL 2000 servers I can
>>choose to drop the current table if it exists at destination. However in SQL Server Management
>>Studio there is no option to drop the existing table. Do I miss something here? How do you guys
>>import in this case? Thanks.
>>
>