Can anyone help?
I just recently imported my Sql server express 2005 db into the full version of sql server 2005... All went according to plan (i used import in studio management 2005 vers not 2005 express) and the data was imported but no stored procedures went with it...
it seemed to only include tables and views...
Is there another way round this?
Unfortunatley i don't have FULL access to the SQL Server 2005 as this is at my hosts... but i have full access to the sql server 2005 express which is locally on my machine
Any advice would be really appreciated
Thanks
ian
Several of the easiest ways:
1. backup the database and restore it to your new server
2. In Object Explorer, you can script out the stored procedures and apply them to the new server
3. Use snapshot replication, but I'd stick with #1 or #2 first.
|||The previous post is correct - the easiest way to make sure you get all objects from one DB to another is to back it up and restore it to another.
If you don't own the other box that might not be possible. You've already got the data, so to get the other objects you can right-click each and script them out. You can also use the scripting model in DMO to do the same thing, but get all of the objects at once. I have a series of tutorials on that starting here:
http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=110
Buck Woody
Carpe Datum
No comments:
Post a Comment