<div>
<div class="content wysiwyg-content">
I have a good working stored procedure to create a text file using BCP where my field delimiter is '$'. &nbsp;Each text file will contain information pertinent to one row of data.<br />
<br />
I have two SQL databases (One is SQL 2005 Express (locally) and one is SQL 2005 Full-version (on web server hosted by another company)). &nbsp;The guys maintaining a website are designing a members only section of the website that links to SQL on the webserver and to a table very similar to mine. &nbsp;They just have fields that are not pertinent to my local SQL structure. &nbsp;I am going to FTP these text file up to a folder on their web server, at which time a windows service will pick them up and add new or update existing records in web server copy of SQL.<br />
<br />
Will I need to create a table on the web server SQL with a structure that is identical to the text file, perform my 'BCP in... and then perform whatever field updates to the live member table using this 'temporary' table?<br />
<br />
I'm assuming I would have to do something like this to match the exported fields from my local database with the fields I'm attempting to import.
</div>
</div>


I have a good working stored procedure to create a text file using BCP where my field delimiter is '$'.  Each text file will contain information pertinent to one row of data.

I have two SQL databases (One is SQL 2005 Express (locally) and one is SQL 2005 Full-version (on web server hosted by another company)).  The guys maintaining a website are designing a members only section of the website that links to SQL on the webserver and to a table very similar to mine.  They just have fields that are not pertinent to my local SQL structure.  I am going to FTP these text file up to a folder on their web server, at which time a windows service will pick them up and add new or update existing records in web server copy of SQL.

Will I need to create a table on the web server SQL with a structure that is identical to the text file, perform my 'BCP in... and then perform whatever field updates to the live member table using this 'temporary' table?

I'm assuming I would have to do something like this to match the exported fields from my local database with the fields I'm attempting to import.

BCP Import/Export

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.