|
Home > Archive > MS SQL Server > October 2006 > SQL Server 2005 Workgroup Edition ?
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 |
SQL Server 2005 Workgroup Edition ?
|
|
|
| Hi,
We are new to SQL Server 2005 Server and find that there is not much
difference between the Workgroup and Standard Edition (We don't use BI at
the present moment) except DTS feature (SSIS).
From our past experience in SQL Server 2000, we don't have many DTS packages
and there is a price difference between the Workgroup & Standard Edition
(Our budget is quite tight). We would like to know for the SQL Server 2005
Workgroup Edition, can we export data from a table (without using query) or
import data to a table as there is no SSIS ? It is the only area we have to
manipulate data.
Your advice is sought.
| |
| Razvan Socol 2006-10-24, 6:33 pm |
| Hi, Peter
You can use the BCP utility to import or export data.
For more information, see:
http://msdn2.microsoft.com/en-us/library/ms162802.aspx
http://msdn2.microsoft.com/en-us/library/aa337544.aspx
Razvan
Peter wrote:
> Hi,
>
> We are new to SQL Server 2005 Server and find that there is not much
> difference between the Workgroup and Standard Edition (We don't use BI at
> the present moment) except DTS feature (SSIS).
>
> From our past experience in SQL Server 2000, we don't have many DTS packages
> and there is a price difference between the Workgroup & Standard Edition
> (Our budget is quite tight). We would like to know for the SQL Server 2005
> Workgroup Edition, can we export data from a table (without using query) or
> import data to a table as there is no SSIS ? It is the only area we have to
> manipulate data.
>
> Your advice is sought.
| |
|
| Hi Peter,
Try import/export wizard.
"Peter" <Peter@discussions.microsoft.com> escreveu na mensagem
news:eI1UOxg5GHA.696@TK2MSFTNGP06.phx.gbl...
> Hi,
>
> We are new to SQL Server 2005 Server and find that there is not much
> difference between the Workgroup and Standard Edition (We don't use BI at
> the present moment) except DTS feature (SSIS).
>
> From our past experience in SQL Server 2000, we don't have many DTS
> packages and there is a price difference between the Workgroup & Standard
> Edition (Our budget is quite tight). We would like to know for the SQL
> Server 2005 Workgroup Edition, can we export data from a table (without
> using query) or import data to a table as there is no SSIS ? It is the
> only area we have to manipulate data.
>
> Your advice is sought.
>
|
|
|
|
|