Convert BDE database to Firebird for use with Sage Timeslips

Instructions to convert BDE database to Firebird for use with “Sage Timeslips Premium and 2017+”

These guidelines detail changing over your Sage Timeslips 2015 and beneath Borland information base to the fresher Firebird SQL Database type for utilization of “Sager Timeslips Premium” and Edition 2017+.

Disclaimer

Backup Warning

Use aware while functioning with the base item usefulness. Always compose a corroboration of your Data earlier to ongoing with “BDE database to Firebird”cutting edge provision. If essential, come across for the help of a Skilled Sage Partner.

Resolution

Significant: We suggest that your organization director utilize these guidelines to act as an illustration of how to convert BDE database to Firebird over your Sage Timeslips information base on a solitary client or multiuser design. Following the suggestions in this report might influence the usefulness of Sage Timeslips and your information base. The organization head or client rolling out these improvements is liable for any issues that might emerge from following these means.

Significant contemplations before you convert

Prerequisites – Must finish the transformation on the server, Firebird Database expects changes to be finished on the actual machine that the data set lives. Assuming you endeavor to start a transformation from a workstation that is highlighted your information base then you will be provoked to go back and forth to your server to start your change.

Working System Considerations – Your Database area for your recently changed over data set just as all future made data sets won’t need to be shared or available by any organization workstation straightforwardly. It just should be open by the server. Inside a Firebird server, the Sage Timeslips software cares the entire figures locate information burden from system workstations. Naturally Firebird will put your each of your information bases into the “C:\ProgramData catalog”. This is a Hidden registry in windows that main the server approaches. On the off chance that you want to see this index you might have to go into your windows organizer view choices and imprint the choice Show stowed away documents and envelopes.

Make a reinforcement of your Sage Timeslips Data and keep in safe spot prior to playing out the assignments beneath. You might have to reestablish this reinforcement in the future to see explicit data that might have been changed by groundwork for the transformation.

• Data Preparation – The issues recorded underneath may influence when you decide to change over your Sage Timeslips data set. Assess this rundown to assist you with deciding when it is best for your organization to change over.
  • Bills and Statements – During the change, A/R installments are typically consequently applied. To lessen potential errors in your maturing sums later change, Sage Timeslips suggests changing over in the wake of producing and supporting bills and explanations.
  • Trade with far off data sets – Slips from far off information bases ought to be traded prior to changing over to your new form. Because of the distinctions in data sets, you should disperse far off data sets in the new form to your far off clients. Distant clients will likewise require the Sage Timeslips CD to refresh Sage Timeslips Remote on their PC. (NOTE: Sage Timeslips Remote is simply pertinent to Sage Timeslips 2011 and more seasoned)
  • Trade with any outsider applications – Make sure that your connected outsider applications are viable with your new form of Sage Timeslips. Trade any information with Sage Timeslips before your transformation i.e., eCenter, Abacus, Amicus, TimeMatters, and so forth
  • Charge Stages – Approve or clean bills off of verification or correction for all customers.
  • Run the framework reports – In your past adaptation of Sage Timeslips, run the System Reports. A few adaptations of Sage Timeslips contain: Slip File Check, Client File Check, and Timeslips Database Check. These reports can recognize issues in your data set. Assuming these reports distinguish mistakes, right the blunders prior to changing over.
  • Settle G/L Transfer Register – If you have TAL (Timeslips Accounting Link), print and conclude the G/L Transfer Register.

Single station transformation

Prior to Converting Close All Other Applications on your workstation

1️⃣ Subsequent to introducing your Sage Timeslips Premium overhaul or single station establishment, open your Sage Timeslips application. On the off chance that this was an overhaul then you ought to be incited to change over your information base. Assuming this was a spic and span establishment then you will be provoked to open a Sage Timeslips information base. Pick Open an Existing Database and peruse to your past form’s information base.

2️⃣ You will be provoked with the Conversion discourse. Assuming you are not incited then pick Open an Existing Database and in the Files of Type field change the sort from main.fdb to main.db and continue to peruse to the area of your Timeslips information you might want to change over. Pick Next.

3️⃣ Assuming you concur, then, at that point, mark I comprehend that charges won’t naturally be refreshed and pick Next. This is compulsory and assuming the decision to not make a reinforcement is made, the transformation won’t continue.

4️⃣ Sage Timeslips requires a reinforcement to be made before beginning the transformation. This is required and assuming that the decision to not make a reinforcement is made, the change won’t continue.

5️⃣ The reinforcement will consequently be named utilizing the date and time stamp for the current date and put in the Timeslips reinforcement envelope situated in C:\users\[windows_user_name]\Documents\Timeslips Backups organizer. Pick Save and permit the reinforcement to finish.

6️⃣ When the reinforcement is finished your Conversion will start. Contingent upon the size of your information base this could require a few minutes or longer to finish. It is really smart to let your machine be and not open some other applications during this time.

7️⃣ When your change finishes, it will either be fruitful or fall flat. Assuming it has bombed click the View Log interface in the lower right corner of your transformation window to see where the disappointment is. You might have to contact support for transformation help, so be ready to have your change sign close by when they request it. In this situation, transformation was fruitful and we can click OK.

8️⃣ Sage Timeslips will open to your changed over information, set aside some effort to check your data set for exactness and contact support assuming you notice any progressions that are erroneous in information.

Multi-station (Network) overhaul change

Prior to Converting Close All Other Applications on your workstation

1. In the wake of introducing Sage Timeslips Premium/2017+, open your Sage Timeslips application. Assuming that this was an update then you ought to be incited to change over your information base. Assuming this was a fresh out of the plastic new full establishment then you will be provoked to open an information base. Pick Open a current data set and peruse to your past form data set.
2. You will be incited with the Database Conversion exchange. In the event that you are not provoked, pick Open a current data set and in the Files of Type field change the sort from main.fdb to main.db and peruse to the area of your Sage Timeslips information you might want to change over. Pick Next.
3. Because of the new information base changes, network establishments presently require the data set to be changed over locally. Assuming you are opening this data set from a workstation that is highlighted a data set that isn’t neighborhood – situated on a server or organization area that isn’t actually on your machine – then, at that point, you should exit out of this transformation interaction and go to the machine where the data set is found and start Sage Timeslips Premium to start the change there. Assuming that machine doesn’t have Sage Timeslips Premium introduced then you should duplicate that data set to the machine that is going about as your Timeslips server and start the change by opening Sage Timeslips Premium on that machine and perusing to your information utilizing the open data set order. On the off chance that you are on the Server playing out your transformation then, at that point, utilize the accompanying strides to finish your organization change.
4. On this exchange you are given your server name and the choice to change over and make this information base accessible for the whole organization or to change it over to use in a solitary station situation. We will decide to make it accessible to the whole organization. You should relegate a name to the data set. The remarks field isn’t needed, but it could be helpful in certain occasions where you might want to give extra detail or clarification. At the point when you are prepared, pick Next.
5. Assuming you concur, then, at that point, mark I comprehend that charges won’t naturally be refreshed and pick Next. This is compulsory and assuming that the decision to not make a reinforcement is made, the change won’t continue.
6. Sage Timeslips requires a reinforcement to be made preceding beginning the change. This is required and assuming that the decision to not make a reinforcement is made, the transformation won’t continue.
7. The reinforcement will naturally be named utilizing the date and time stamp for the current date and set in the Timeslips reinforcement envelope situated in C:\users\[windows_user_name]\Documents\Timeslips Backups organizer. Pick Save and permit the reinforcement to finish.
8. When the reinforcement is finished, the transformation will start. Contingent upon the size of your information base this could require a few minutes or longer to finish. It is really smart to let your machine be and not open some other applications during this time.
9. When your transformation finishes it will either succeed or fizzle. Assuming that it fizzles, click the View Log connect in the lower right corner of your transformation window to see where the disappointment is. You might have to contact support for transformation help, so be ready to have your change log convenient when they request it. In this situation, transformation was fruitful and we can click OK.
10. Sage Timeslips Premium will open your changed over information base. Set aside some effort to check your information base for exactness and contact support in the event that you notice any erroneous information.

Multi-station (Network) new establishment transformation

Prior to Converting Close All Other Applications on your workstation

1. In the wake of introducing Sage Timeslips Premium/2017+, open your Sage Timeslips application. Pick Open a current data set.
2. You will see another Open Database exchange. This discourse just shows Registered Databases, new information bases made in Timeslips Premium, data sets that have been enlisted with the TSADMIN instrument, or data sets changed over by Sage Timeslips Premium will show up in this exchange. You really want to peruse to your earlier form information base utilizing the 3-speck button instrument in the lower right hand corner.
3. In this Open exchange, you will see any MAIN.FDB or MAIN.DB Database record types naturally. Peruse to the area of your Sage Timeslips information you might want to change over, select the Main.DB document and pick Open.
4. When you pick your data set to change over, click OK.
5. You will be incited with the Conversion discourse. In the event that you are not incited then pick Open an Existing Database and in the Files of Type field, change the sort from main.fdb to main.db and peruse to the area of your Sage Timeslips information you are changing over. Pick Next.
6. Because of the new data set change, network establishments presently require the data set to be changed over locally. Assuming you are opening this information base from a workstation that is highlighted a data set that isn’t neighborhood – situated on a server or organization area that isn’t truly on your machine – you should exit out of this transformation cycle and go to the machine where the data set is found and start Sage Timeslips Premium to start the change there. Assuming that machine doesn’t have Sage Timeslips Premium introduced, then, at that point, you should duplicate that data set to the machine that is going about as your Timeslips Premium server and start the transformation by opening Sage Timeslips on that machine and perusing to your information utilizing the open data set order. On the off chance that you are on the Server playing out your transformation, then, at that point, utilize the accompanying strides to finish your organization change
7. On this exchange, you are given your Server name and the choice to change over and make this Database accessible for the whole organization, or to change over it for use in a solitary station situation. We will decide to make it accessible for the whole organization. Give the information base a name. The remarks field isn’t needed, but it could be valuable in certain occurrences where you might want to give extra detail or clarification. At the point when you are prepared pick Next.
8. Assuming you concur, then, at that point, mark I comprehend that expenses won’t naturally be refreshed and pick Next. This is required and assuming the decision to not make a reinforcement is made, the transformation won’t continue.
9. Sage Timeslips requires a reinforcement to be made preceding beginning the transformation. This is required and on the off chance that the decision to not make a reinforcement is made, the transformation won’t continue.
10. The reinforcement will naturally be named utilizing the date and time stamp for the current date and put in the Timeslips reinforcement organizer situated in C:\users\[windows_user_name]\Documents\Timeslips Backups envelope. Pick Save and permit the reinforcement to finish.
11. When the reinforcement is finished, the change will start. Contingent upon the size of your data set this could require a few minutes or longer to finish. It is smart to let your machine be and not open some other applications during this time.
12. When your change finishes it will either succeed or fizzle. In the event that it fizzles, click the View Log connect in the lower right corner of your change window to see where the disappointment is. You might have to contact support for change help, so be ready to have your transformation log convenient when they request it. In this situation, transformation was effective and you should click OK.
13. Sage Timeslips Premium/2017+ will open your changed over information base. Set aside some effort to check your information base for precision and contact support assuming you notice any inaccurate information.

Get in Touch

Experiencing any issue regarding Convert BDE database to Firebird for use with Sage Timeslips” Contact our Sage Experts’ they will assist you to solve your query. You can reach Sage Accounting Experts via Live Chat Link, phone call (Number Display on Screen) or via Email at info@accountscomparison.com

Also Read Helpful Sage Articles:

Sage 50 2021