SQLMint
This is a quick way to copy data from one table to the other. The other table will be created.
See example below, using the AdventureWorks2012 sample database from Microsoft
SELECT
[AddressID] ,[AddressLine1] ,[AddressLine2] ,[City] ,[StateProvinceID] ,[PostalCode] ,[SpatialLocation] ,[rowguid] ,[ModifiedDate]
into MyList
FROM [AdventureWorks2012].[Person].[Address]
Result (19614 row(s) affected)
Video by Kendra Little
Run this on your Sharepoint database instance.
SELECT TOP 1000 [VersionId]
,[Version]
,[Id]
FROM [SPS2010_Config].[dbo].[Versions]
Use this Microsoft website – click here – to check the version number. For example, for id 4 l got 14.0.6131.5003 which is CU 12/2012
SQL Server Books l recommend:
We will be showing how to import database data from Edgar, with SQL code as well as SSIS Import Wizard configuration settings.
“Since 1934, the SEC has required disclosure in forms and documents. In 1984, EDGAR began collecting electronic documents to help investors get information”
First import the latest master.idx from http://www.sec.gov/edgar/indices/fullindex.htm and edit the file as shown below.
Create a database called Edgar
Create a table called master1 using T-SQL code below
Right click on Edgar database,click Tasks, then Import dat and use settings below.
USE [Edgar]
GO
/****** Object: Table [dbo].[master_02102013] Script Date: 2/10/2013 1:41:59 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[master_02102013](
[MasterID] [int] IDENTITY(1,1) NOT NULL,
[CIK] [varchar](50) NULL,
[Company Name] [varchar](200) NULL,
[Form Type] [varchar](50) NULL,
[Date Filed] [varchar](50) NULL,
[Filename] [varchar](50) NULL,
CONSTRAINT [PK_master_02102013] PRIMARY KEY CLUSTERED
(
[MasterID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
Make sure Identity insert is checked off. Also make sure you select delete existing rows NOT append row data.
Example Search T-SQL Query after import is completed.
SELECT TOP 100000 [MasterID]
,[CIK]
,[Company Name]
,[Form Type]
,[Date Filed]
,[Filename]
FROM [Edgar].[dbo].[master]
Result
Coming soon – a script, to extract ftp filepaths from above results and possibly a script [in python] tp download from ftp.sec.gov all the files into appropriate columns in our database, which currently houses 53,398 rows of data.
————–
Scriot for downloading ONE file, from say data in first row of table created above. Save this as test.scr
anonymous
<your email address goes in here>
cd edgar/data/1000045/
ls *.txt
get 0001193125-13-046001.txt
quit
Script for a batchfile to execute above. Save as, for example: gosec.bat
cls
ftp -s:test.scr ftp.sec.gov
Click here for this useful set of tools.
The Microsoft® SQL Server® 2012 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2012. It includes the latest versions of:
An important component of this feature pack is:
Microsoft® SQL Server® 2012 Native Client
On technet, theres an excellent of free videos you can access, download which help towards SQL 2008 MCM certification. Click here for the link.
If downloading all – expect to save about 15Gb+ for these video files.
Below is a directory listing from my download.
SQL Server Reporting Services [SSRS] 2008 Problem: Maximum request length exceeded
Error l get:
Error : There was an exception running the extensions specified in the config file. —> Maximum request length exceeded.
Click on image below for larger version.
Solution:
Edit the file web.config, found in:
C$Program FilesMicrosoft SQL ServerMSRS10_50.RPTReporting ServicesReportServer
Change line:
<httpRuntime executionTimeout=”9000″ />
to:
<httpRuntime executionTimeout = “9000” maxRequestLength=”500000″ />
And then restart the SQL Server Reporting Services [SSRS] service.
This should fix the issue.