SQL Replication to a report database

Yahoo Archive
1

Sandra,

 

Actually, I simply used the wizards in SQL Server to do it. Read up on the Help associated with it as Microsoft's 'Help' is often more confusing than helpful. If I recall, I found some good stuff on the 'net to clarify some of my questions. The wizard will create all the jobs on both servers and do all the work for you.

 

Create a publisher (and what it publishes) on your E9 SQL server, and a subscriber (and what it subscribes to) on the reporting server. In our case, this was our EPM server. I think you need to create the shared directory (that the snapshots will be created in and read from) before any of that so when you are going through the setup the directory already exists. The first run through takes forever as it's essentially a full backup, copy and restore, but then the following ones are quite quick.

 

We also created a support database where we store views and functions used to 'look inside' our E9 db, and I setup transactional replication for that one over to our EPM server - really that was overkill since there are no real transactions to speak of, but I wanted to learn.

 

if you want more specifics, email me - mike@...

 

Mike

2

We want to replicate Epicor 905 data to a second sql server for reporting.  Since I can’t use sql’s replication, what tool would you recommend?

 

Thanks for any suggestions.

 

Greg


CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
3

Depending on database size and acceptable time delay… I have set up a couple companies with a scheduled backup, move, and restore of the SQL database to another server for reporting purposes.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Greg Payne
Sent: Wednesday, January 15, 2014 5:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] SQL Replication to a report database

 




We want to replicate Epicor 905 data to a second sql server for reporting.  Since I can’t use sql’s replication, what tool would you recommend?

 

Thanks for any suggestions.

 

Greg

 

CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."



4

I have seen your post of that script and in fact use parts of it when I am moving Live to Pilot, but am wanting more close to real time with this.

 

Greg

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ned
Sent: Wednesday, January 15, 2014 5:37 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] SQL Replication to a report database

 

 

Depending on database size and acceptable time delay… I have set up a couple companies with a scheduled backup, move, and restore of the SQL database to another server for reporting purposes.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Greg Payne
Sent: Wednesday, January 15, 2014 5:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] SQL Replication to a report database

 





We wa nt to replicate Epicor 905 data to a second sql server for reporting.  Since I can’t use sql’s replication, what tool would you recommend?

 

Thanks for any suggestions.

 

Greg

 

CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this mess age is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."





CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
5

Greg,

 

I'm not sure why you say you cannot run SQL's replication? I have to assume you mean transactional replication - which you are correct - will not work, or some other issues/Progress/etc...

 

We run a combination of transactional for a support database (where we have a lot of queries waiting on E10) and Snapshot for our 9.05.606 databases over to our EPM server (SQL2008 on both sides). I run a few lesser companies every hour and our main one two times a day - once at lunch and once in the evening.

 

I can help with some answers if you want to explore it.

Mike



---In vantage@yahoogroups.com, <gpayne@...> wrote:

I have seen your post of that script and in fact use parts of it when I am moving Live to Pilot, but am wanting more close to real time with this.

 

Greg

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ned
Sent: Wednesday, January 15, 2014 5:37 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] SQL Replication to a report database

 

 

Depending on database size and acceptable time delay… I have set up a couple companies with a scheduled backup, move, and restore of the SQL database to another server for reporting purposes.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Greg Payne
Sent: Wednesday, January 15, 2014 5:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] SQL Replication to a report database

 





We wa nt to replicate Epicor 905 data to a second sql server for reporting.  Since I can’t use sql’s replication, what tool would you recommend?

 

Thanks for any suggestions.

 

Greg

 

CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this mess age is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."





CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
6

I was trying to setup transactional replication and got stopped. I am researching other 3rd party options and wondering if anyone has experience with some that can be almost realtime.

 

I am running sql 2008 64bit and am looking to replicate to sql 2012.

 

Any help is greatly appreciated.

 

Greg

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of mkgross69@...
Sent: Wednesday, January 15, 2014 6:49 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: SQL Replication to a report database

 

 

Greg,

 

I'm not sure why you say you cannot run SQL's replication? I have to assume you mean transactional replication - which you are correct - will not work, or some other issues/Progress/etc...

 

We run a combination of transactional for a support database (where we have a lot of queries waiting on E10) and Snapshot for our 9.05.606 databases over to our EPM server (SQL2008 on both sides). I run a few lesser companies every hour and our main one two times a day - once at lunch and once in the evening.

 

I can help with some answers if you want to explore it.

Mike



---In vantage@yahoogroups.com, <gpayne@...> wrote:

I have seen your post of that script and in fact use parts of it when I am moving Live to Pilot, but am wanting more close to real time with this.

 

Greg

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ned
Sent: Wednesday, January 15, 2014 5:37 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] SQL Replication to a report database

 

 

Depending on database size and acceptable time delay… I have set up a couple companies with a scheduled backup, move, and restore of the SQL database to another server for reporting purposes.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Greg Payne
Sent: Wednesday, January 15, 2014 5:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] SQL Replication to a report database

 




We wa nt to replicate Epicor 905 data to a second sql server for reporting.  Since I can’t use sql’s replication, what tool would you recommend?

 

Thanks for any suggestions.

 

Greg

 

CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this mess age is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."



 

CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
7


Hi Mike,

Would you mind giving some input about how you are running SQL snapshot replication for EPM? I am trying to find a way to replicate our live db for EPM too without using Epicor Replication which has proven to be very faulty in the past.

Thank you,

Sandra

---In vantage@yahoogroups.com, <mkgross69@...> wrote:

Greg,

 

I'm not sure why you say you cannot run SQL's replication? I have to assume you mean transactional replication - which you are correct - will not work, or some other issues/Progress/etc...

 

We run a combination of transactional for a support database (where we have a lot of queries waiting on E10) and Snapshot for our 9.05.606 databases over to our EPM server (SQL2008 on both sides). I run a few lesser companies every hour and our main one two times a day - once at lunch and once in the evening.

 

I can help with some answers if you want to explore it.

Mike



---In vantage@yahoogroups.com, <gpayne@...> wrote:

#ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 filtered #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 filtered #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 filtered #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 filtered #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 filtered #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 {font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 filtered #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 p.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424MsoNormal, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 li.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424MsoNormal, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 div.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 a:link, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 span.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424MsoHyperlink {color:blue;text-decoration:underline;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 a:visited, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 span.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424MsoHyperlinkFollowed {color:purple;text-decoration:underline;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 p {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 code {font-family:"Courier New";} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 pre {margin:0in;margin-bottom:.0001pt;font-size:10.0pt;font-family:"Courier New";} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 tt {font-family:"Courier New";} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 p.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424MsoAcetate, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 li.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424MsoAcetate, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 div.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424MsoAcetate {margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma", "sans-serif";} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 span.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424HTMLPreformattedChar {font-family:Consolas;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 p.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424attach, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 li.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424attach, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 div.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424attach {margin-right:0in;margin-left:0in;font-size:9.0pt;font-family:"Arial", "sans-serif";} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 p.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424bold, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 li.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424bold, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 div.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424bold {margin-right:0in;margin-left:0in;font-size:10.0pt;font-family:"Arial", "sans-serif";font-weight:bold;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 p.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424green, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 li.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424green, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 div.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424green {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";color:#628C2A;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 p.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424replbq, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 li.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424replbq, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 div.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424replbq {margin:3.0pt;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 p.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424ad, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 li.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424ad, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 div.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424ad {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 p.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424underline, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 li.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424underline, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 div.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424underline {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 span.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424yshortcuts {} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 p.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424ad1, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 li.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424ad1, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 div.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424ad1 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 p.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424ad2, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 li.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424ad2, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 div.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424ad2 {margin-right:0in;margin-bottom:7.5pt;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 p.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424underline1, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 li.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424underline1, #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 div.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424underline1 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";text-decoration:underline;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 span.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424yshortcuts1 {font-family:"Verdana", "sans-serif";font-weight:bold;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 span.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424yshortcuts2 {font-family:"Verdana", "sans-serif";font-weight:normal;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 span.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424EmailStyle34 {font-family:"Calibri", "sans-serif";color:#1F497D;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 span.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424BalloonTextChar {font-family:"Tahoma", "sans-serif";} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 .ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424MsoChpDefault {font-size:10.0pt;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 filtered #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 {margin:1.0in 1.0in 1.0in 1.0in;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 div.ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424WordSection1 {} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 filtered #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 {} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 filtered #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 {font-family:Symbol;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 filtered #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 {font-family:"Courier New";} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 filtered #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 {font-family:Wingdings;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 filtered #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 {font-family:Wingdings;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 filtered #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 {font-family:Wingdings;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 filtered #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 {font-family:Wingdings;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 filtered #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 {font-family:Wingdings;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 filtered #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 {font-family:Wingdings;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 filtered #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 {font-family:Wingdings;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 ol {margin-bottom:0in;} #ygrps-yiv-1175155870 #ygrps-yiv-1175155870ygrps-yiv-1736935818 #ygrps-yiv-1175155870ygrps-yiv-1736935818ygrps-yiv-1795825424 ul {margin-bottom:0in;}

I have seen your post of that script and in fact use parts of it when I am moving Live to Pilot, but am wanting more close to real time with this.

 

Greg

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ned
Sent: Wednesday, January 15, 2014 5:37 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] SQL Replication to a report database

 

 

Depending on database size and acceptable time delay… I have set up a couple companies with a scheduled backup, move, and restore of the SQL database to another server for reporting purposes.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Greg Payne
Sent: Wednesday, January 15, 2014 5:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] SQL Replication to a report database

 





We wa nt to replicate Epicor 905 data to a second sql server for reporting.  Since I can’t use sql’s replication, what tool would you recommend?

 

Thanks for any suggestions.

 

Greg

 

CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this mess age is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."





CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."