Sql Server Data Transfer. In the first instance of conopen i need to read data from some textboxes and open the connection to sql server. It its a low volume one time process youre better off with using t sql to directly insert the data.
The transfer sql server objects task transfers one or more types of objects in a sql server database between instances of sql server. If you already created then select it. Download and configure data transfer application you need to download install and configure the data transfer application.
The transfer class is a utility class that provides tools to transfer objects and data.
In the name field enter sqlserver. Connect to your ms sql server by providing the sql server hostname pipeline name sql server port sql server username password database name and schema name. 3select tasks 4select copy. We will use the dbcc shrinkfile command to migrate the data.