2000 to 2005
-
I am developing an intranet site that will use a SQL Server 2000 database. I wanted to work at home from my laptop, so I backed up the 2000 database from the server with EM and restored it into SQL Server 2005 on my laptop (version 9.00.1399.06). When I got home with it, I found that the tables were there, but they were empty.
I backed up and restored again, this time with Mgmt Studio, and the data magically appeared. Then, there were no permissions on the stored procs, so I had to set all of those. Is there an easier way to do this? There is no "i" in team, but idiot has two. -
Why not develop @ home on SQL 2000?
Cheers,Ben Sullins
bensullins.com
Beer is my primary key... -
After you restore you need to remove/resolve orphan users. that might be the reason why you dint get permissions at first.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com -
I had a login mapped to the user in the database, so I don't think there were any orphans. But what about the empty tables?
There is no "i" in team, but idiot has two.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply