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 |
|
feffe
Starting Member
2 Posts |
 Posted - 2007-04-16 : 09:20:43
|
| I need to make something that copies all tabels (structures + data) from a progress database into another mssql2000 database.THANKS! |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-04-16 : 09:26:21
|
| Simplest way would be to create SSIS package. Another way is to generate a script of all the database objects and run it on destination DB to create the schema and then use either BCP or BULK INSERT to copy the data.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
feffe
Starting Member
2 Posts |
Posted - 2007-04-16 : 10:00:00
|
| Please tell me more about SSIS |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-16 : 12:27:31
|
| It called dts in sql2k. You need odbc driver of progress database on sql server to make them talk. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-04-16 : 12:32:03
|
| (1) Create a DB. (2) In Management Studio, right click on the DB -> All Tasks -> Import Data. follow through the wizard.************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-04-16 : 13:59:33
|
| "mssql2000 database"Please note that this is a SQL 2005 forum.Can you just BACKUP the "source" database and Restore to the "destination" database?Knowing what the problem is you are trying to solve might help folk here give appropriate advice.Kristen |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-16 : 16:22:29
|
| May not since source is progress database. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-04-17 : 04:08:17
|
Haha ... The "into another mssql2000 database" confused me into thinking that meant a "work in progress database"  Kristen |
|
|
|
|
|
|
Copy Tables + content + structure from DB1 to DB2