PDA

Click to See Complete Forum and Search --> : [RESOLVED] How to copy a full schema from one SQL 2005 server to another one

JonnyPoet
June 29th, 2008, 06:17 AM
Hi friends !

I have used Access mdb's in before now I'm going to use SQL 2005
Migration from mdb to sql 2005 was easy as I have a tool for this.
After migrating from access to sql2005 I did a lot of changes in the datastructure too, so it would need lots of work to do this again in the firm. Now I'm ready with this and I want to take all the new Sql 2005 database data from the sql server at home to my new installed sql 2005 server in the firm. I tried this using publishing wizzard doing a script, but I dont know whats wrong, I only got the structe of the database, not the data.
Can anyone tell me how to use the script correct, especially which scriptoptions I should use, so I also get the data inserted into the database at the other location?
TheCPUWizard
June 29th, 2008, 08:47 AM
If you want the data also, then backup/restore is the easiest way.

If you created the database with it's own files, then you can detach, copy, and attach.
JonnyPoet
June 29th, 2008, 12:27 PM
If you want the data also, then backup/restore is the easiest way.

If you created the database with it's own files, then you can detach, copy, and attach.Sounds great so I just tried it. But it refused to work because both machines have a different file system so it didn't find the data where it awaited them to be. One machine is Vista, one is XP. Then I tried to set the data exact to where it awaited they should be.
Then it said that the data found are from another machine then the expected ones.
------
edited
Handled . worked
I created exactly the same path as I have had on my home PC which has ( Vista ) english Path names on my XP machine in the firm where I have german path names. I found the correct pathname in the errormessage,
Then I did the backup in the exact destination where it obviously was expected because the errormessage said file not found in... ( I dont know why the path to the data is also stored in the backup file, BTW ) and when I retried to backup then it doesn't give any error but said 'completed'.

Great. Thx. Have learned a lot by that.