Answer the question
In order to leave comments, you need to log in
How to migrate DB from postgreSQL dump to MS SQL 2016?
Good afternoon. There are files containing a SQL script (*.sql) that creates a demo database and fills it with data (actually, this is a backup created by the pg_dump utility) in postgreSQL. The size of the database itself is about 2.5 GB, the request file is about 950 MB.
It is necessary to transfer somehow quickly this business to MS SQL. If you just stupidly run it, it falls out into errors (excerpt from the log):
83 Warning Performance warning: String load failed. Pkg:{AA8EB8CD-7A51-11D0-92C3-00A0C9138C45} LANG:0409 ID:508 VisualStudio 2018/06/07 09:13:17.237
148 ERROR The color 'Popup' in category 'de7b1121-99a4-4708-aedf-15f40c9b332f' does not exist. Color Theme Service 2018/06/07 09:15:55.792
160 ERROR System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown. at System.String.CtorCharArray(Char[] value) at Microsoft.VisualStudio.Text.Implementation.BinaryStringRebuilder.GetText(Span span) at Microsoft.VisualStudio.Text.Implementation.TextSnapshot.GetText(Span span) at Microsoft.VisualStudio.Text .SnapshotSpan.GetText() at Microsoft.VisualStudio.Editor.Implementation.TextDocData.GetLineText(Int32 iStartLine, Int32 iStartIndex, Int32 iEndLine, Int32 iEndIndex, String& pbstrBuf) at Microsoft.VisualStudio.Package.Source.GetText() at Microsoft.VisualStudio .Package.Source.BeginParse(Int32 line, Int32 idx, TokenInfo info, ParseReason reason, IVsTextView view, ParseResultHandler callback) at Microsoft.VisualStudio.Package.ViewFilter.GetDataTipText(TextSpan[] aspan, String& textValue) at Microsoft.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question