SupportSupport

Hi,

I'm trying to import a SQL huge script to insert data to my table, what i tried is to paste the script to my sql editor but unfortunately i get an out of memory exception which is normal. I then tried:

1. Click on import table data by selecting my table.
2. Select my Sql file(my insert statements), By default the encoding is cp1252, I click on next.
3. On the Data datagrid, on the first column you would see the part of the insert statement which is wrong.
4. I then click on next and select current database radio button, i click on next and click on import.

The import always failed. Is there another way to import table data from one database to another?

Regards,
Salim

Hi,
I tried to export a table in CSV format and import it to another database's table (Empty & with same formatting and no constraint) and run the command below:

select * from assign;
@run assign.csv;

I still get an error message while executing. Can you please tell me what i am doing wrong.

Thanks
Salim

Some updates:
I tried to import my file as:

@export on;
@export set filename="c:\alltables.csv" appendfile="clear" format="csv";
select * from assign;

It export the file successfully.

Now i tried to import it using the DBVis GUI, its work fine.

I deleted the table data, place my csv file in the right path & tried to import it using the command run:

select * from to_assign;
@run alltables.csv;

I still get an error. Please tell me what i'm doing wrong.

Thanks.
Salim