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 |
|
skw234
Starting Member
4 Posts |
 Posted - 2010-08-20 : 09:07:53
|
| I exported a db from SQL 2k5 ot SQL 2k8 but none of the views exported. Need help in exporting frm 32bit db 2005 to 64bit 2008 server.skw234 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-08-20 : 10:38:12
|
| Why export? Backup from the 2005 server and restore on the 2008 server.Assuming you used the script database wizard, did you select the views when you generated the script?--Gail ShawSQL Server MVP |
 |
|
|
skw234
Starting Member
4 Posts |
Posted - 2010-08-20 : 11:04:08
|
| What I did was use the script database wizard and exported all obj's. Didn't think to restore from that script. It's been two days since migrating to 2008 and the database now has new data because users are using it. Should I try the following action plan:===1.) backup only the changes made since exporting the database?2.) delete the exported db3.) Restore from the script4.) Restore the latest changes |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-08-20 : 13:24:13
|
| If it was just the views that failed to script, script just the views from SQL 2005 and then run that script on the 2008 server.My question was why you did export/import initially instead of just restoring a backup.--Gail ShawSQL Server MVP |
|
|
|
skw234
Starting Member
4 Posts |
Posted - 2010-08-20 : 14:45:05
|
| "Newbie"Information that I received form MSFT. Since two different architectures I thought I could simply export. Also, didn't find any straight cut tutorials or howto's on exporting from 32bit SQL 2005 Svr to 64bit SQL 2008 Svr |
|
|
|
skw234
Starting Member
4 Posts |
Posted - 2010-08-20 : 14:45:20
|
| Thanks for the responses |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-08-20 : 15:23:37
|
quote:
Originally posted by skw234
Information that I received form MSFT.
Wow. I would question the person who gave you information implying there were difficulties.quote:
Also, didn't find any straight cut tutorials or howto's on exporting from 32bit SQL 2005 Svr to 64bit SQL 2008 Svr
No tutorials necessary. Take a database backup of the 2005 database, copy to the 2008 server. Restore the backup.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Export DB from SQL 2k5 32bit to 64bit 2k8 failure