<div>
You can also create a Linked Server in MS SQL to the Pervasive SQL tool to facilitate the pulling down of data. &nbsp;You can write a script and schedule it using SQL task scheduler.<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ff772782.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ff772782.aspx</a><br />
<br />
Drew
</div>


You can also create a Linked Server in MS SQL to the Pervasive SQL tool to facilitate the pulling down of data.  You can write a script and schedule it using SQL task scheduler.

http://msdn.microsoft.com/en-us/library/ff772782.aspx [http://msdn.microsoft.com/en-us/library/ff772782.aspx]

Drew

<div>
I think I just spoke to you on the phone Bill...connecting the dots...<br />
<br />
Thank you for your advice and I will be in touch!
</div>


I think I just spoke to you on the phone Bill...connecting the dots...

Thank you for your advice and I will be in touch!

<div>
I'm now using the staging method in SSIS and it works great
</div>


I'm now using the staging method in SSIS and it works great

<div>
<div class="content wysiwyg-content">
I'm starting with the development of a .NET application and find that a ODBC connection to Pervasive SQL is too slow specially when I run too many Iif statements. When I run the same queries in VS with MS SQL it performs much faster <br />
<br />
What I'm doing is develop the .NET app together with MS SQL now<br />
<br />
Now I need a tool to sync data from PSQL to MS SQL potentially on a schedule.<br />
<br />
I'm just learning MS SQL. Does MS SQL have a native feature for this to say sync tables or what other tools are out there for this?
</div>
</div>


I'm starting with the development of a .NET application and find that a ODBC connection to Pervasive SQL is too slow specially when I run too many Iif statements. When I run the same queries in VS with MS SQL it performs much faster 

What I'm doing is develop the .NET app together with MS SQL now

Now I need a tool to sync data from PSQL to MS SQL potentially on a schedule.

I'm just learning MS SQL. Does MS SQL have a native feature for this to say sync tables or what other tools are out there for this?

Moving/syncing data from Pervasive SQL to MS SQL

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.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.