Withdata Software

Tag: Sql Server

  • Batch transfer data from MySQL tables to SQL Server without programming

    Want to batch transfer data from MySQL to SQL Server ? Using DBCopier, a native GUI software, a MySQL to SQL Server converter, you can batch transfer data from MySQL (MariaDB, Percona) to SQL Server easily and fast. Can run in GUI mode, Step by Step, just a few mouse clicks. Can run in Command…

  • Batch transfer data from Access tables to SQL Server without programming

    Want to batch transfer data from Access to SQL Server ? Using DBCopier, a native GUI software, a Access to SQL Server converter, you can batch transfer data from Access to SQL Server easily and fast. Can run in GUI mode, Step by Step, just a few mouse clicks. Can run in Command line, for…

  • Upsert data from TXT (“|” pipe delimited text) file to SQL Server without programming

    Want to upsert data from TXT (“|” pipe delimited text) file to SQL Server ? Upsert: inserts rows into a table if they do not already exist, or updates them if they do. Using FileToDB, a native GUI tool, you can upsert data from TXT (“|” pipe delimited text) file to SQL Server easily and…

  • Create Excel report from SQL Server database

    Want to create Excel report from SQL Server database? Using MsSqlToExcel, you can generate excel report from SQL Server easily and fast, no need to program, no need learn VBA, just a few mouse clicks! Here you can download and install MsSqlToExcel. Create an Excel report based on SQL Server Click “Export From Query” at…

  • Batch import RTF files into SQL Server [IMAGE, VARBINARY(MAX)] (BLOB) without programming

    Want to batch import RTF (Rich Text Format) documents into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) or [IMAGE, VARBINARY(MAX)] (BLOB) column? Using SqlLobEditor, you can import bulk rtf files into SQL Server [TEXT, NTEXT, VARCHAR(MAX), NVARCHAR(MAX)] (CLOB) or [IMAGE, VARBINARY(MAX)] (BLOB) easily and fast, just a few mouse clicks. Here you can download and…

  • Some ETL (Extract-Transform-Load) tools for SQL Server

    Withdata Software provide some ETL (Extract-Transform-Load) tools for SQL Server: FileToDB Load TXT, CSV, TSV, XML, JSON, Excel, SQL, RDF, INI data to SQL Server DBToFile Export SQL Server data to TXT, CSV, TSV, XML, JSON, Excel, SQL files DBCopier Copy data between SQL Server and other rational databases MongoToDB Ease your MongoDB to SQL…

  • Parse RDF file and save to SQL Server

    Want to parse RDF file and save to SQL Server ? Want to schedule and automate this importing task? To import Xml format RDF file (.rdf, .owl) to SQL Server, https://www.withdata.com/blog/rdftomssql/sql-server-import-rdf.html To import RDF Turtle file (.ttl, .n3) to SQL Server, https://www.withdata.com/blog/rdftomssql/ttl-to-sql-server.html To import RDF N-Triples file (.nt, .ntriples) to SQL Server, https://www.withdata.com/blog/rdftomssql/n-triples-to-sql-server.html To import…

  • How to select N random records from a SQL Server table

    If you want to select N random records from a SQL Server table, you need to change the clause as follows: select top N * from tableName order by newid() For example, to select 5 random customers in the customers table, you use the following query: select top 5 * from customers order by newid()…

  • Batch import data from JSON files to SQL Server without programming

    Want to batch import data from files to SQL Server ? Using JsonToMsSql, you can batch import data from JSON files to SQL Server easily and fast, no need to program, just a few mouse clicks! Here you can download and install JsonToMsSql. Batch import data from JSON files to SQL Server Click “Wizard –…

  • Batch import data from XML files to SQL Server without programming

    Want to batch import data from files to SQL Server ? Using XmlToMsSql, you can batch import data from XML files to SQL Server easily and fast, no need to program, just a few mouse clicks! Here you can download and install XmlToMsSql. Batch import data from XML files to SQL Server Click “Wizard –…