Want to parse online RSS feeds and save to SQL Server ? Want to schedule and automate this importing task?
Using File To DB, a native GUI tool for Windows, MacOS, and Linux, you can import online RSS feeds 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 repeatable Scheduled Tasks and Streams.
Import online RSS feeds to SQL Server
Choose SQL Server and logon.
Click “Wizard – 1 File To 1 Table” at task dialog.
Select “Source Type” with “Url”.
then show the wizard.
1. Input the RSS feeds URL, and download to XML file.
2. Open the saved XML file.
3. Config target SQL Server table.
You can create new SQL Server table by XML struct, just a few mouse clicks.
Select table and config fields.
4. Summary.
5. Import.
See importing results in SQL Server table
Import RSS feed to SQL Server in command line
Save “RSS feed to SQL Server” session, then you can:
- Import RSS feed to SQL Server in Windows command line.
- Import RSS feed to SQL Server in Linux command line.
- Import RSS feed to SQL Server in macOS command line.
Set scheduled tasks for importing RSS feed to SQL Server
You can schedule and automate this importing task by:
1) Save session and create .bat file.