Ars Technica

Bulk Insert into Sql server?

Hello all. <BR>I have a collection of comma delimited text files sitting on a network drive. This data needs to be imported daily into our production tables. The destination tables vary depending upon ...
Visual Studio Magazine

Using SQL Bulk Insert with the .NET Framework

SQL Bulk Insert has been tuned over the years to work well with the Microsoft .NET Framework. This tutorial shows you how to take advantage of its power. SQL Bulk Insert is not a new technology. In ...
Visual Studio Magazine

Hooking ASP.NET Apps into SQL Server 2012

Use custom-built .NET Framework 4.0 classes to connect an ASP.NET Web application to a SQL Server 2012 database. In my recent article, I showed how to connect .NET 4.0 C# and Visual Basic applications ...
Ars Technica

Mysql 5: 'openquery()' (MS SQL Server) like functionality?

I am trying obtain some data from a Cache database into a Mysql database using Cache's SQL Gateway.<BR><BR>Getting the data out of Cache is easy, but I am not sure about the easiest way to get it into ...