Thank you Steve for the response. It helps me to plan.

Hi Steve,

Are systems from DC2 being shut down and physically moved or copied to a new place (DC3).

Yes DC2 is going to be shutdown and physically moved to new place.

Just...

Go the result after slight change. Thank you J. Drew Allen.

WITH Server_Databases AS
(
    select a.Server,d.dbname [DB_name], COUNT(d.dbname) OVER(PARTITION BY dbname) AS cnt
  ...

Sorry, I was in legacy server. Now i have run the same in SQL 2019.

Following is the error

Msg 207, Level 16, State 1, Line 52

Invalid column name 'dbname'.

Got it -...

• This reply was modified 1 year, 7 months ago by  Saran.
• This reply was modified 1 year, 7 months ago by  Saran.

Thanks, I am getting following error. Also, I do not want to pass any where clause.

I am thinking, following is giving me what I need, but I do not know...

Yes, default.

utf8mb4 - utf8mb4_0900_ai_ci

Thank you, I am planning the same to update some symbol.

I have tried  different line/row separator, could not find how to export properly. The load data is working good if...

CR LF is breaking my data load into mysql, I have updated CR LF as space ' ' and load is working good.

I thought of using quotename. select * is not working some places found that because of CR LF.

Sorry, I just shown as example.

I am using STRING_AGG from INFORMATION_SCHEMA.columns and other system table to populate all the columns to BCP.

The other option is to convert those CR and LF to text values that you can then convert after importing.  If you use a tab delimited - or pipe...

HI,

fields terminated by "|" (the delimiter you used above), enclosed by '"' escaped by '"'

I have used the same test. But wherever there is a split it load as zero...

No Guru, I am doing test, I tried to use quotename(field3,CHAR(34)) still in the output i am seeing split. I think quotename is not working.

To add: the split comes with...

• This reply was modified 1 year, 10 months ago by  Saran.

Thanks for the CR LF note, I am trying to bcp out from mssql and load to mysql.

Yes, I used notepad++. PFA image. BCP out is coming like this.

First two columns are integer

• This reply was modified 1 year, 10 months ago by  Saran.