x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 138 subscribers
  • Views 1014 views
  • Users 0 members are here
Browse Forums
Announcements
237
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
210
topics
416
replies
Sage Intelligence Reporting
121
topics
322
replies
PSK

Is it possible to use the SQL Import / Export Wizard to copy from PRODUCTION to PILOT?

SUGGESTED
Posted By

I need to update the SO and PO tables on a daily basis to test an automation customization I am working on.  Has anyone used the Microsoft SQL Import / Export Wizard to create an SSIS package to copy data from PRODUCTION to PILOT?  Does that work?  If so, are there any potential issues I need to worry about when I do this?

Parents
  • 0
    SUGGESTED

    I have no specific experience on MSSQL import/export. But when you update tables on a database level you bypass all applicative controls. So if you update a subset of data you may create inconsistencies in the database and corrupt your database with no other choice but to restore the last uncorrupted backup. Due to the risk, I recommend to never do this on a production folder. If someone has a different experience to share, I would be very interested.

Reply
  • 0
    SUGGESTED

    I have no specific experience on MSSQL import/export. But when you update tables on a database level you bypass all applicative controls. So if you update a subset of data you may create inconsistencies in the database and corrupt your database with no other choice but to restore the last uncorrupted backup. Due to the risk, I recommend to never do this on a production folder. If someone has a different experience to share, I would be very interested.

Children

*Community Hub is the new name for Sage City