Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Table copy between Services

Status
Not open for further replies.
pdbowling

pdbowling

Programmer
Mar 28, 2003
267
0
0
US
I am using Sybase Central (5.0.0.3311) and SQL Anywhere 10 (10.0.1.3716).

I have 2 similar databases on the same physical server with there own inividual Services running. I need to copy a table from one database to the other database-with the same table name.

I tried this

Code: 
INSERT MyService2.MyDbName.MyOwnerName.MyTableName
SELECT *
  FROM MyService1.MyDbName.MyOwnerName.MyTableName

I ran this in an ISQL window opened on MyService1

I get the error:
"Primary Key 'MyTableName' is not unique"

How Should I go about copying a table between databases using different services?

Thanks everyone.
Patrick

Patrick is a distributor of Republic Magazine ( -free pdf copy downloadable ) and the webmaster of
 
Status
Not open for further replies.

Similar threads

bokswager
  • Locked
  • Question
modifying column on large table
Replies
0
Views
56
bokswager
bokswager
rocco
  • Locked
  • Question
Reset Table Column Back to 0
Replies
1
Views
46
rocco
rocco
mark1110
  • Locked
  • Question
import text file into sybase table
Replies
1
Views
37
PDreyer
PDreyer
gchalise
  • Locked
  • Question
BCP of few records from a big table
Replies
1
Views
50
PDreyer
PDreyer
santhosh238
  • Locked
  • Question
Need script for finding out duplicate indexes on tables
Replies
1
Views
43
PDreyer
PDreyer

Part and Inventory Search

Sponsor

Back
Top