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 |
|
satya068
Posting Yak Master
233 Posts |
 Posted - 2010-03-23 : 07:06:43
|
| Hi..i have to create a databasa structure for a perticualr database in the destination server2 sql2005 based on source database server1 sql 2005.could you pls let me know if u have any idea.thanxyashu |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2010-03-23 : 07:10:29
|
| Generate Script from Server 1 and execute in server 2Right click DB->Script database as->Create to->Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
 |
|
|
satya068
Posting Yak Master
233 Posts |
Posted - 2010-03-23 : 07:14:41
|
| hi..senthil,do u want me to copy the script from that perticulat database server1 and paste into the server2 database and execute?thanxyashu |
|
|
|
satya068
Posting Yak Master
233 Posts |
Posted - 2010-03-23 : 07:16:26
|
| hi senthil,when i executed the script in server 2there is an error message'Msg 1801, Level 16, State 3, Line 2Database 'PAS_CALC' already exists.DBCC execution completed. If DBCC printed error messages, contact your system administrator.thanxyashu |
|
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2010-03-23 : 07:19:50
|
| Sorry,Task-> generate Script!Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
|
|
|
satya068
Posting Yak Master
233 Posts |
Posted - 2010-03-23 : 07:39:26
|
| senthil..it worked,great work thanx senthil.yashu |
|
|
|
satya068
Posting Yak Master
233 Posts |
Posted - 2010-03-23 : 07:44:35
|
| senthil...do u have any idea how to check the firewall settings in remotdesktop sql server 2005 for the port 1433 and 1434.thanxyashu |
|
|
|
|
|
|
Creating Database structure