Page 1 of 1

Copy data from one IDE to another

Posted: Thu Jan 04, 2024 3:43 am
by atostaine
I have some rows in the local database (SQL Server) on one PC and I want to copy it into a new PC. Has anyone done this before?

I tried the SQL Server import/export wizard but it gives and error that @RRNO is read only.

Re: Copy data from one IDE to another

Posted: Fri Jan 05, 2024 11:04 pm
by cesarrafael
Can't you just ignore the RRNO on the import?

Re: Copy data from one IDE to another

Posted: Sat Jan 06, 2024 12:22 am
by atostaine
The error was on the export. There is a function in SQL server to export the database, I don't want to have to do each table.