Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Michael71
Posting Yak Master
126 Posts |
 Posted - 2006-12-22 : 11:38:50
|
| How do I upload test data from a frame maker database to SQL database tables using ODBC. |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-12-22 : 11:55:52
|
| Take a look at Data Transformation Services (DTS) in 2000, or SQL Server Intergation Services (SSIS) in 2005 |
 |
|
|
Michael71
Posting Yak Master
126 Posts |
Posted - 2006-12-22 : 12:33:57
|
| Okay I'm looking at this in the book, but where do I start. Please. |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-12-22 : 13:32:29
|
| Either start creating a package or use the Import Wizard, which will create a simple package for you. |
|
|
|
Michael71
Posting Yak Master
126 Posts |
Posted - 2006-12-22 : 13:47:33
|
| Do both databases has to be on the same server? |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-12-22 : 14:14:08
|
| No, when you create the package/import you will be prompted to enter the details for each server. |
|
|
|
Michael71
Posting Yak Master
126 Posts |
Posted - 2006-12-22 : 20:18:05
|
| So the only way I can import data from a different server is by creating a package? Also when I try tranfering the data from Filemaker to SQL Server database, an error comes up and tells me that the data can not be put in SQl Server, because of the datatype mismatch. I solved this by changing the data type to text for the time being. SQL 2005, doesn't like the data source that's coming from Filemaker either. However, SQL 2003 tranfers all 15 tables of data and automaticlly changes the datatypes for me. Do you know anyreason why SQL 2005 don't like the data source. |
|
|
|
|
|
|
Uploading data from a different type of database