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?