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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Easy way to copy items to different DB

Status
Not open for further replies.
smeyer56

smeyer56

IS-IT--Management
Joined
Oct 16, 2002
Messages
206
Location
US
What is the easiest way to copy certain not all inventory items from one DB to another?
Great Plains 8

Thanks
 
Sort by date Sort by votes
You could use Data Transformation Services (DTS) in SQL Server and write a query to select the items you want.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kgeorge71
  • Locked
  • Question Question
Bank Recs not tying to GL in Dynamics Great Plains
Replies
0
Views
2K
kgeorge71
kgeorge71
ACCT PDC
  • Locked
  • Question Question
Switched to DirectDeposit Payroll and now entries not carrying through to bank reconciliation
Replies
1
Views
1K
ACCT PDC
ACCT PDC
Bill Hewitt
  • Locked
  • Question Question
How to "register" RealWorld software when you have lost the code
Replies
0
Views
968
Bill Hewitt
Bill Hewitt
C.MtZ
  • Locked
  • Question Question
How to create a menu Item on Dynamics Gp menu
Replies
0
Views
1K
C.MtZ
C.MtZ
tabikat
  • Locked
  • Question Question
how to see where a return is applied in GP A/P?
Replies
0
Views
1K
tabikat
tabikat

Part and Inventory Search

Sponsor

Back
Top