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 |
|
imnoob
Starting Member
3 Posts |
 Posted - 2008-04-02 : 07:57:01
|
| I am new to |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-04-02 : 07:58:54
|
quote:
Originally posted by imnoob
I am new to
did you hit post before you finished your question?Em |
 |
|
|
imnoob
Starting Member
3 Posts |
Posted - 2008-04-02 : 08:01:07
|
| Please ignore the previous post, I accidently enter'ed. I am new to DTS/SSIS, but I need to transfer some table data from the machine A to machine B due to software upgrade, machine A is running SQL 2000 whereas machine B is running SQL 2005. I would like to know what is the easiest/safest way to do this? And what do i need to take into consideration when doing this? and i need to delete some dummy/testing data on machine B before i start to transfer the data from machine B, would the truncate command be fine with it?please advice...thanks a million. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-02 : 10:03:33
|
| Yup. you just need a package with sql task to truncate table data and data flow task to transfer data from one server to other (you may use OLEDB source & OLEDB destination for this). I'm assuming you have data in correct format in your source server else you have to do some kind of data transformation too.b/w is this for a one time transfer or do you want to do it periodically? |
|
|
|
imnoob
Starting Member
3 Posts |
Posted - 2008-04-02 : 21:19:31
|
| For now, it is only 1 time deal, but maybe future will need to reuse it for other server deployment. So now, I plan to create a package which will start truncate a number of tables and then only transfer the data. I tried to truncate the tables manually, but some tables are non-truncatable...:( it stated some reference/foreign key integrity something..i'm stuck..fyi, i tried on sql2005. And I plan to use the SQL management studio(sql2005) on my notebook to connect and transfer the data from sql2000 server to sql 2005. Is this the correct way? ( that i use sql2005 client) to transfer the sql2000 data to sql2005. |
|
|
|
|
|
|
Data Transfer from SQL 2000 to SQL 2005