V
V
Vyacheslav Stepko2018-06-07 12:42:58
SQL Server
Vyacheslav Stepko, 2018-06-07 12:42:58

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.

Tell me how to make the transfer in the shortest time with minimal losses? Not really willing to deploy a postgreSQL server. Is it possible to somehow convert the file for MS SQL?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
Sergey, 2018-06-07
@slavapride

https://docs.microsoft.com/en-us/sql/integration-s...
did the import work incorrectly?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question