Link data from one DB to another

[Mnbvoj]

I'm wondering if it's possible to copy data from a couple of fields of one DB to the same fields in another DB. I enter data in one DB, and have a field that if selected, opens another DB. Some fields in the 2nd DB are the same as the 1st DB. Can't the info I installed in the 1st populate those fields in the 2nd? I've tried Link, Linked & Relationship, without any luck.

[ddhsoftwareadmin]

Hi there,

Thanks for your post. The DB Popup field is the one that is closest to what you describe. It creates what looks and behaves like a text field but when you select the drop down button it shows you the list of records in a related table. Tapping a record in that table will copy the value for the field you assigned in the setup into the first database. And there is a group feature where you can set up a group of db popup fields that all get copied when one is selected.

More info here;

http://www.ddhsoftware.com/knowledgebase.html?read=253

Hope this helps!

[Veritas]

I have been working on databases where I need to extract information from 23 fields in one database to another using then dB popup group function. The problem is that it only extracts the info from the first 10. Is there a limit for extracting info or am I doing something wrong?


Sent from my iPhone using Tapatalk

[curtterp]

I have been working on databases where I need to extract information from 23 fields in one database to another using then dB popup group function. The problem is that it only extracts the info from the first 10. Is there a limit for extracting info or am I doing something wrong?


Sent from my iPhone using Tapatalk

I am assuming that you are working with HanDBase on your iPhone.

The following is from the iPhone user documentation

Maximum number of DB popups in a group: 10

[Veritas]

I have been working on databases where I need to extract information from 23 fields in one database to another using then dB popup group function. The problem is that it only extracts the info from the first 10. Is there a limit for extracting info or am I doing something wrong?


Sent from my iPhone using Tapatalk

I am assuming that you are working with HanDBase on your iPhone.

The following is from the iPhone user documentation

Maximum number of DB popups in a group: 10

Thank you for your answer. I figured as much, just wanted to make sure.
Then there’s one more thing I would wish for in the next update: increase the number of dB popups in a group. The other thing is increase number of fields


Sent from my iPhone using Tapatalk

[nateliv]

There are following options available:

- If databases are on the same server then use SQL Server Management Studio (SSMS) or Transact-SQL (insert into table2 select * from database2.dbo.table1)

If databases are on different servers then

- Create a linked server and access data from another SQL Server by using SSMS or TSQL.
- Backup source database, copy it to the destination server, restore as a new database and access data with SSMS or TSQL (insert into table2 select * from database2.dbo.table1)
- Create an export script for source database or table (e.g. using SSMS, right click on db, Tasks, Export Data), run it against target server and then access data with SSMS or TSQL

The best and easiest way in case of different servers is the one with linked server, but this option is not always possible due to security reasons.