moving tables from one server to another

Hi all,
I'm new to MSSql server and need some advice on this. I need to move a few
tables from a database in server A to another database in server B. How
should I do this?
Thanks,
TL
Use DTS in SQL Server 2000
or
Use Integration Service in SQL Server 2005
Regards
Amish Shah
|||TL
As an alternative you can use SELECT * INTO TableName
FROM Database.dbo.TableName WHERE 1=2
--In above script SQL Server will move only structure's table ( it has some
drawbacks (does not move constraints,keys))
WHERE 1=1 the actual data will be moved as well
"TL" <TL@.discussions.microsoft.com> wrote in message
news:8A3E6BD1-8FFE-4258-8273-BBD15781F950@.microsoft.com...
> Hi all,
> I'm new to MSSql server and need some advice on this. I need to move a few
> tables from a database in server A to another database in server B. How
> should I do this?
> Thanks,
> TL

moving tables from one server to another

Hi all,
I'm new to MSSql server and need some advice on this. I need to move a few
tables from a database in server A to another database in server B. How
should I do this?
Thanks,
TLUse DTS in SQL Server 2000
or
Use Integration Service in SQL Server 2005
Regards
Amish Shah|||TL
As an alternative you can use SELECT * INTO TableName
FROM Database.dbo.TableName WHERE 1=2
--In above script SQL Server will move only structure's table ( it has some
drawbacks (does not move constraints,keys))
WHERE 1=1 the actual data will be moved as well
"TL" <TL@.discussions.microsoft.com> wrote in message
news:8A3E6BD1-8FFE-4258-8273-BBD15781F950@.microsoft.com...
> Hi all,
> I'm new to MSSql server and need some advice on this. I need to move a few
> tables from a database in server A to another database in server B. How
> should I do this?
> Thanks,
> TL