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 |
|
ostinoh
Yak Posting Veteran
66 Posts |
 Posted - 2011-09-19 : 13:27:21
|
| Hello - We currently have a SQL 2005 database environment and are looking to export some data off and onto another db server that would be SQL 2008. They would be custom scripts that would pull the data and insert it into the new db.My question is can I use SQL 2008 for the new server and database even if the data is coming from a SQL 2005 server?Regards,David |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-19 : 13:34:24
|
| yep. no problem with that. I assume scripts will be written on SQL 2008 box using linked server connection created to SQL 2005 to pull required data as per yur logic.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
SQL 2005 data exported to New SQL 2008 database?