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 |
|
bpsintl
Posting Yak Master
132 Posts |
 Posted - 2009-04-02 : 09:54:24
|
| I have developed my app with SQL 2008 Express and I now want to change hosts / servers and they only provide SQL 2005 Workgroup.What is the best way to migrate the database over?It is only 20Mb in size. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-04-02 : 10:52:13
|
| use SSIS/DTS to import/export data.. and recreate indexes, jobs etc..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
bpsintl
Posting Yak Master
132 Posts |
Posted - 2009-04-02 : 10:58:56
|
| So there would not be any problems? |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-04-02 : 16:08:26
|
| Well I cant guarantee that.. if you are not using any of the newer 2008 features, getting just the data out of 2008 server shoudlnt be too difficult.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
bpsintl
Posting Yak Master
132 Posts |
Posted - 2009-04-02 : 16:13:36
|
| Thanks. After initial tests it looks good. I have to re-create pk's and indexes manually though along with my sp's and functions |
|
|
|
|
|
|
SQL 2008 to SQL 2005