Copy data from one IDE to another

This Q&A forum allows users to post and respond to "How Do I Do ....." questions. Please do not use to report (suspected) errors - you must use your regional help desk for this. The information contained in this forum has not been validated by LANSA and, as such, LANSA cannot guarantee the accuracy of the information.
Post Reply
atostaine
Posts: 696
Joined: Wed Jan 20, 2016 7:38 am

Copy data from one IDE to another

Post 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.
Art Tostaine
cesarrafael
Posts: 32
Joined: Tue Dec 01, 2015 3:44 am

Re: Copy data from one IDE to another

Post by cesarrafael »

Can't you just ignore the RRNO on the import?
atostaine
Posts: 696
Joined: Wed Jan 20, 2016 7:38 am

Re: Copy data from one IDE to another

Post 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.
Art Tostaine
Post Reply