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 |
|
nimesh69
Starting Member
30 Posts |
 Posted - 2001-09-10 : 04:13:31
|
| Greetings!I've a DB in SQL7 which I wish to port to SQL2k. While I do this using Backup/restore or Import/export, everything goes on fine but when I access any tabels using dbo-user it says object not found.In SQL7, I create Login "xyz" and user for my database as "xyz" with "xyz" login and then i create all the objects i.e. tables/sps/view etc. using "xyz" login.After porting if I fire select * from mytable it gives me object does not exist. However, if I type select * from xyz.mytable, it works fine!!Does anyone know why is this so? am I leaving out something that is required to be done in sql2000?Though, I'm doing my work with a work around but I'm sure I should be able to do it straight with backup/restore or import/export.The work around:I import or restore the db from sql7 and then create new db in sql2000 and do bulk select * - insert into from the restored db to new db.Thanks in advance.Nimesh |
|
|
|
|
|
Problems - migrating DB from SQL7 to SQL2000