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 |
|
chedderslam
Posting Yak Master
223 Posts |
 Posted - 2008-01-30 : 11:12:00
|
| I am trying to make a copy of my live MSSQL 2005 Database to my local Developer Edition install.To copy the whole database, I am using MS Database Publishing Wizard. I am able to copy the tables and data without problem, but after generating the sql file and running the query against the local db to copy everything, I get errors for the stored procedures.The stored procedures name is preceded by a login, for instance:EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [matthews].[proc_allitemswithtaxologykeylist]( @list varchar(7777) ) AS (sql code below)I have created the user "matthews" on the local instance and given the account DBO role membership in the database. What else do I need to do?Is there a better way to synch live databases with a local install, perhaps from within management studio itself? I am more experienced with enterprise manager, but 2005 won't let you connect with it.Thank you for any help. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-01-30 : 11:16:14
|
| Why don't you restore the backup of live database on your local server?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
chedderslam
Posting Yak Master
223 Posts |
Posted - 2008-01-30 : 11:52:13
|
| If I try to back up the database to file, the only location Management Studio provides for the file on disk to back up to is on the live server. I am on a shared host(crystaltech), so I don't have access to the file system. They would charge to send me the backup, I think. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2008-01-30 : 12:47:32
|
quote:
Originally posted by chedderslam
If I try to back up the database to file, the only location Management Studio provides for the file on disk to back up to is on the live server. I am on a shared host(crystaltech), so I don't have access to the file system. They would charge to send me the backup, I think.
Is xp_cmdshell enabled?Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
|
|
|
|
|
copying stored procedures