 | |
Can I use SQL DB Publishing Wizard to transfer from SQL2005 to SQL
microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Can I use SQL DB Publishing Wizard to transfer from SQL2005 to SQL -
12-18-2008
, 10:32 AM
#2
| |||
| |||
|
|
I have a DB that was put on a temporary server, which has SQL2005. I need to transfer the DB back, but the original server is SQL2000 SP2. I found a posting on another forum / newsgroup that seems to indicate that the Microsoft SQL Server Database Publishing Wizard might work for this. I realize that the SQL 2000 is behind a few service packs, and would likely need to be updated, as well, this is not an issue. Basicly, my question is, will this work? Will I be able to run this utility, to move the DB, its associated views, etc, back to the SQL 2000 server? |
you should be fine, as long as you are not using features new in SQL 2005.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#3
| |||
| |||
|
|
I have a DB that was put on a temporary server, which has SQL2005. I need to transfer the DB back, but the original server is SQL2000 SP2. I found a posting on another forum / newsgroup that seems to indicate that the Microsoft SQL Server Database Publishing Wizard might work for this. I realize that the SQL 2000 is behind a few service packs, and would likely need to be updated, as well, this is not an issue. Basicly, my question is, will this work? Will I be able to run this utility, to move the DB, its associated views, etc, back to the SQL 2000 server? |
you should be fine, as long as you are not using features new in SQL 2005.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#4
| |||
| |||
|
|
I have a DB that was put on a temporary server, which has SQL2005. I need to transfer the DB back, but the original server is SQL2000 SP2. I found a posting on another forum / newsgroup that seems to indicate that the Microsoft SQL Server Database Publishing Wizard might work for this. I realize that the SQL 2000 is behind a few service packs, and would likely need to be updated, as well, this is not an issue. Basicly, my question is, will this work? Will I be able to run this utility, to move the DB, its associated views, etc, back to the SQL 2000 server? |
you should be fine, as long as you are not using features new in SQL 2005.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#5
| |||
| |||
|
|
I have a DB that was put on a temporary server, which has SQL2005. I need to transfer the DB back, but the original server is SQL2000 SP2. I found a posting on another forum / newsgroup that seems to indicate that the Microsoft SQL Server Database Publishing Wizard might work for this. I realize that the SQL 2000 is behind a few service packs, and would likely need to be updated, as well, this is not an issue. Basicly, my question is, will this work? Will I be able to run this utility, to move the DB, its associated views, etc, back to the SQL 2000 server? |
you should be fine, as long as you are not using features new in SQL 2005.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#6
| |||
| |||
|
|
I have a DB that was put on a temporary server, which has SQL2005. I need to transfer the DB back, but the original server is SQL2000 SP2. I found a posting on another forum / newsgroup that seems to indicate that the Microsoft SQL Server Database Publishing Wizard might work for this. I realize that the SQL 2000 is behind a few service packs, and would likely need to be updated, as well, this is not an issue. Basicly, my question is, will this work? Will I be able to run this utility, to move the DB, its associated views, etc, back to the SQL 2000 server? |
you should be fine, as long as you are not using features new in SQL 2005.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#7
| |||
| |||
|
|
I have a DB that was put on a temporary server, which has SQL2005. I need to transfer the DB back, but the original server is SQL2000 SP2. I found a posting on another forum / newsgroup that seems to indicate that the Microsoft SQL Server Database Publishing Wizard might work for this. I realize that the SQL 2000 is behind a few service packs, and would likely need to be updated, as well, this is not an issue. Basicly, my question is, will this work? Will I be able to run this utility, to move the DB, its associated views, etc, back to the SQL 2000 server? |
you should be fine, as long as you are not using features new in SQL 2005.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#8
| |||
| |||
|
|
I have a DB that was put on a temporary server, which has SQL2005. I need to transfer the DB back, but the original server is SQL2000 SP2. I found a posting on another forum / newsgroup that seems to indicate that the Microsoft SQL Server Database Publishing Wizard might work for this. I realize that the SQL 2000 is behind a few service packs, and would likely need to be updated, as well, this is not an issue. Basicly, my question is, will this work? Will I be able to run this utility, to move the DB, its associated views, etc, back to the SQL 2000 server? |
you should be fine, as long as you are not using features new in SQL 2005.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#9
| |||
| |||
|
|
I have a DB that was put on a temporary server, which has SQL2005. I need to transfer the DB back, but the original server is SQL2000 SP2. I found a posting on another forum / newsgroup that seems to indicate that the Microsoft SQL Server Database Publishing Wizard might work for this. I realize that the SQL 2000 is behind a few service packs, and would likely need to be updated, as well, this is not an issue. Basicly, my question is, will this work? Will I be able to run this utility, to move the DB, its associated views, etc, back to the SQL 2000 server? |
you should be fine, as long as you are not using features new in SQL 2005.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#10
| |||
| |||
|
|
I have a DB that was put on a temporary server, which has SQL2005. I need to transfer the DB back, but the original server is SQL2000 SP2. I found a posting on another forum / newsgroup that seems to indicate that the Microsoft SQL Server Database Publishing Wizard might work for this. I realize that the SQL 2000 is behind a few service packs, and would likely need to be updated, as well, this is not an issue. Basicly, my question is, will this work? Will I be able to run this utility, to move the DB, its associated views, etc, back to the SQL 2000 server? |
you should be fine, as long as you are not using features new in SQL 2005.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.