Hi,
I am a newbie. I want to copy a table from the production database and paste
it in the test database thus replacing the old copy in the test database.
What's the best way to do it? Thanks in advance.
did you hear "=?Utf-8?B?c2hhcm1hbg==?="
<sharman@.discussions.microsoft.com> say in
news:1BFF4909-65DF-41E8-A37C-518BE50D44EC@.microsoft.com:
> I am a newbie. I want to copy a table from the production database and
> paste it in the test database thus replacing the old copy in the test
> database. What's the best way to do it? Thanks in advance.
>
check books online for the Import/Export wizard.
Neil MacMurchy
http://spaces.msn.com/members/neilmacmurchy
http://spaces.msn.com/members/mctblogs
|||Sharman,
Try the Import/Export Wizard in DTS (Data Transformation Services). See the
SQL Books Online for more information.
HTH
Jerry
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:1BFF4909-65DF-41E8-A37C-518BE50D44EC@.microsoft.com...
> Hi,
> I am a newbie. I want to copy a table from the production database and
> paste
> it in the test database thus replacing the old copy in the test database.
> What's the best way to do it? Thanks in advance.
|||Unfortunately, you cannot copy and paste a table from one database to
another. The easiest way to do this is using the DTS Export/Import Wizard.
From the SOURCE database, if you right click the table name, go to ALL
TASKS, then Export Data, it will bring up the wizard.
1) Hit next on the welcome screen.
2) Hit next on the source screen. By starting from the source, you won't
have to enter this information.
3) On the destination screen, enter the server name and choose the
database. You won't have to do anything with the table name at this point.
You just have to tell it where to send the table.
4) The next screen actually has a direct "copy tables..." option, but I
prefer the copy objects and data method, which is the last choice on the
screen. Choose that and click next.
5) You should now be at the "Select Objects to Copy" screen. Here it's
safe to leave the top options, but you MUST uncheck a few and make some
changes at the bottom of the screen. First, UNCHECK BOTH Copy all objects
and Use default options.
6) Hit the "Select Objects" button and mark the table you want to copy.
Then click OK.
7) Now, hit the "Options" button and turn off Copy database users and roles
as well as object-level permissions. You can copy object permissions ONLY if
you have the same database users and roles in the source and destination
databases. If you don't, the copy users and roles choice could help, unless
some of the users or roles already exist.. where it would fail. The easiest
method is to uncheck both of these boxes and reconfigure permissions for the
table once it's copied over.
8) Now hit OK, then next and finish all the way through until your table is
done and copied.
Hope this helps!
Bryan
"sharman" wrote:
> Hi,
> I am a newbie. I want to copy a table from the production database and paste
> it in the test database thus replacing the old copy in the test database.
> What's the best way to do it? Thanks in advance.
|||Thanks a lot. I thought there was some easy way like copying and pasting.
"Jerry Spivey" wrote:
> Sharman,
> Try the Import/Export Wizard in DTS (Data Transformation Services). See the
> SQL Books Online for more information.
> HTH
> Jerry
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:1BFF4909-65DF-41E8-A37C-518BE50D44EC@.microsoft.com...
>
>
|||Sharman,
Instead of using DTS you can restore the production backup file on your
test environment.
Erwin
sharman schreef:
[vbcol=seagreen]
> Thanks a lot. I thought there was some easy way like copying and pasting.
> "Jerry Spivey" wrote:
Showing posts with label newbie. Show all posts
Showing posts with label newbie. Show all posts
Sunday, March 25, 2012
copying tables in SQL Server
Hi,
I am a newbie. I want to copy a table from the production database and paste
it in the test database thus replacing the old copy in the test database.
What's the best way to do it? Thanks in advance.did you hear "examnotes"
<sharman@.discussions.microsoft.com> say in
news:1BFF4909-65DF-41E8-A37C-518BE50D44EC@.microsoft.com:
> I am a newbie. I want to copy a table from the production database and
> paste it in the test database thus replacing the old copy in the test
> database. What's the best way to do it? Thanks in advance.
>
check books online for the Import/Export wizard.
Neil MacMurchy
http://spaces.msn.com/members/neilmacmurchy
http://spaces.msn.com/members/mctblogs|||Sharman,
Try the Import/Export Wizard in DTS (Data Transformation Services). See the
SQL Books Online for more information.
HTH
Jerry
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:1BFF4909-65DF-41E8-A37C-518BE50D44EC@.microsoft.com...
> Hi,
> I am a newbie. I want to copy a table from the production database and
> paste
> it in the test database thus replacing the old copy in the test database.
> What's the best way to do it? Thanks in advance.|||Unfortunately, you cannot copy and paste a table from one database to
another. The easiest way to do this is using the DTS Export/Import Wizard.
From the SOURCE database, if you right click the table name, go to ALL
TASKS, then Export Data, it will bring up the wizard.
1) Hit next on the welcome screen.
2) Hit next on the source screen. By starting from the source, you won't
have to enter this information.
3) On the destination screen, enter the server name and choose the
database. You won't have to do anything with the table name at this point.
You just have to tell it where to send the table.
4) The next screen actually has a direct "copy tables..." option, but I
prefer the copy objects and data method, which is the last choice on the
screen. Choose that and click next.
5) You should now be at the "Select Objects to Copy" screen. Here it's
safe to leave the top options, but you MUST uncheck a few and make some
changes at the bottom of the screen. First, UNCHECK BOTH Copy all objects
and Use default options.
6) Hit the "Select Objects" button and mark the table you want to copy.
Then click OK.
7) Now, hit the "Options" button and turn off Copy database users and roles
as well as object-level permissions. You can copy object permissions ONLY i
f
you have the same database users and roles in the source and destination
databases. If you don't, the copy users and roles choice could help, unless
some of the users or roles already exist.. where it would fail. The easies
t
method is to uncheck both of these boxes and reconfigure permissions for the
table once it's copied over.
8) Now hit OK, then next and finish all the way through until your table is
done and copied.
Hope this helps!
Bryan
"sharman" wrote:
> Hi,
> I am a newbie. I want to copy a table from the production database and pas
te
> it in the test database thus replacing the old copy in the test database.
> What's the best way to do it? Thanks in advance.|||Thanks a lot. I thought there was some easy way like copying and pasting.
"Jerry Spivey" wrote:
> Sharman,
> Try the Import/Export Wizard in DTS (Data Transformation Services). See t
he
> SQL Books Online for more information.
> HTH
> Jerry
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:1BFF4909-65DF-41E8-A37C-518BE50D44EC@.microsoft.com...
>
>|||Sharman,
Instead of using DTS you can restore the production backup file on your
test environment.
Erwin
sharman schreef:
[vbcol=seagreen]
> Thanks a lot. I thought there was some easy way like copying and pasting.
> "Jerry Spivey" wrote:
>sql
I am a newbie. I want to copy a table from the production database and paste
it in the test database thus replacing the old copy in the test database.
What's the best way to do it? Thanks in advance.did you hear "examnotes"
<sharman@.discussions.microsoft.com> say in
news:1BFF4909-65DF-41E8-A37C-518BE50D44EC@.microsoft.com:
> I am a newbie. I want to copy a table from the production database and
> paste it in the test database thus replacing the old copy in the test
> database. What's the best way to do it? Thanks in advance.
>
check books online for the Import/Export wizard.
Neil MacMurchy
http://spaces.msn.com/members/neilmacmurchy
http://spaces.msn.com/members/mctblogs|||Sharman,
Try the Import/Export Wizard in DTS (Data Transformation Services). See the
SQL Books Online for more information.
HTH
Jerry
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:1BFF4909-65DF-41E8-A37C-518BE50D44EC@.microsoft.com...
> Hi,
> I am a newbie. I want to copy a table from the production database and
> paste
> it in the test database thus replacing the old copy in the test database.
> What's the best way to do it? Thanks in advance.|||Unfortunately, you cannot copy and paste a table from one database to
another. The easiest way to do this is using the DTS Export/Import Wizard.
From the SOURCE database, if you right click the table name, go to ALL
TASKS, then Export Data, it will bring up the wizard.
1) Hit next on the welcome screen.
2) Hit next on the source screen. By starting from the source, you won't
have to enter this information.
3) On the destination screen, enter the server name and choose the
database. You won't have to do anything with the table name at this point.
You just have to tell it where to send the table.
4) The next screen actually has a direct "copy tables..." option, but I
prefer the copy objects and data method, which is the last choice on the
screen. Choose that and click next.
5) You should now be at the "Select Objects to Copy" screen. Here it's
safe to leave the top options, but you MUST uncheck a few and make some
changes at the bottom of the screen. First, UNCHECK BOTH Copy all objects
and Use default options.
6) Hit the "Select Objects" button and mark the table you want to copy.
Then click OK.
7) Now, hit the "Options" button and turn off Copy database users and roles
as well as object-level permissions. You can copy object permissions ONLY i
f
you have the same database users and roles in the source and destination
databases. If you don't, the copy users and roles choice could help, unless
some of the users or roles already exist.. where it would fail. The easies
t
method is to uncheck both of these boxes and reconfigure permissions for the
table once it's copied over.
8) Now hit OK, then next and finish all the way through until your table is
done and copied.
Hope this helps!
Bryan
"sharman" wrote:
> Hi,
> I am a newbie. I want to copy a table from the production database and pas
te
> it in the test database thus replacing the old copy in the test database.
> What's the best way to do it? Thanks in advance.|||Thanks a lot. I thought there was some easy way like copying and pasting.
"Jerry Spivey" wrote:
> Sharman,
> Try the Import/Export Wizard in DTS (Data Transformation Services). See t
he
> SQL Books Online for more information.
> HTH
> Jerry
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:1BFF4909-65DF-41E8-A37C-518BE50D44EC@.microsoft.com...
>
>|||Sharman,
Instead of using DTS you can restore the production backup file on your
test environment.
Erwin
sharman schreef:
[vbcol=seagreen]
> Thanks a lot. I thought there was some easy way like copying and pasting.
> "Jerry Spivey" wrote:
>sql
copying tables in SQL Server
Hi,
I am a newbie. I want to copy a table from the production database and paste
it in the test database thus replacing the old copy in the test database.
What's the best way to do it? Thanks in advance.did you hear "=?Utf-8?B?c2hhcm1hbg==?="
<sharman@.discussions.microsoft.com> say in
news:1BFF4909-65DF-41E8-A37C-518BE50D44EC@.microsoft.com:
> I am a newbie. I want to copy a table from the production database and
> paste it in the test database thus replacing the old copy in the test
> database. What's the best way to do it? Thanks in advance.
>
check books online for the Import/Export wizard.
--
Neil MacMurchy
http://spaces.msn.com/members/neilmacmurchy
http://spaces.msn.com/members/mctblogs|||Sharman,
Try the Import/Export Wizard in DTS (Data Transformation Services). See the
SQL Books Online for more information.
HTH
Jerry
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:1BFF4909-65DF-41E8-A37C-518BE50D44EC@.microsoft.com...
> Hi,
> I am a newbie. I want to copy a table from the production database and
> paste
> it in the test database thus replacing the old copy in the test database.
> What's the best way to do it? Thanks in advance.|||Unfortunately, you cannot copy and paste a table from one database to
another. The easiest way to do this is using the DTS Export/Import Wizard.
From the SOURCE database, if you right click the table name, go to ALL
TASKS, then Export Data, it will bring up the wizard.
1) Hit next on the welcome screen.
2) Hit next on the source screen. By starting from the source, you won't
have to enter this information.
3) On the destination screen, enter the server name and choose the
database. You won't have to do anything with the table name at this point.
You just have to tell it where to send the table.
4) The next screen actually has a direct "copy tables..." option, but I
prefer the copy objects and data method, which is the last choice on the
screen. Choose that and click next.
5) You should now be at the "Select Objects to Copy" screen. Here it's
safe to leave the top options, but you MUST uncheck a few and make some
changes at the bottom of the screen. First, UNCHECK BOTH Copy all objects
and Use default options.
6) Hit the "Select Objects" button and mark the table you want to copy.
Then click OK.
7) Now, hit the "Options" button and turn off Copy database users and roles
as well as object-level permissions. You can copy object permissions ONLY if
you have the same database users and roles in the source and destination
databases. If you don't, the copy users and roles choice could help, unless
some of the users or roles already exist.. where it would fail. The easiest
method is to uncheck both of these boxes and reconfigure permissions for the
table once it's copied over.
8) Now hit OK, then next and finish all the way through until your table is
done and copied.
Hope this helps!
Bryan
"sharman" wrote:
> Hi,
> I am a newbie. I want to copy a table from the production database and paste
> it in the test database thus replacing the old copy in the test database.
> What's the best way to do it? Thanks in advance.|||Thanks a lot. I thought there was some easy way like copying and pasting.
"Jerry Spivey" wrote:
> Sharman,
> Try the Import/Export Wizard in DTS (Data Transformation Services). See the
> SQL Books Online for more information.
> HTH
> Jerry
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:1BFF4909-65DF-41E8-A37C-518BE50D44EC@.microsoft.com...
> > Hi,
> >
> > I am a newbie. I want to copy a table from the production database and
> > paste
> > it in the test database thus replacing the old copy in the test database.
> > What's the best way to do it? Thanks in advance.
>
>|||Sharman,
Instead of using DTS you can restore the production backup file on your
test environment.
Erwin
sharman schreef:
> Thanks a lot. I thought there was some easy way like copying and pasting.
> "Jerry Spivey" wrote:
> > Sharman,
> >
> > Try the Import/Export Wizard in DTS (Data Transformation Services). See the
> > SQL Books Online for more information.
> >
> > HTH
> >
> > Jerry
> > "sharman" <sharman@.discussions.microsoft.com> wrote in message
> > news:1BFF4909-65DF-41E8-A37C-518BE50D44EC@.microsoft.com...
> > > Hi,
> > >
> > > I am a newbie. I want to copy a table from the production database and
> > > paste
> > > it in the test database thus replacing the old copy in the test database.
> > > What's the best way to do it? Thanks in advance.
> >
> >
> >
I am a newbie. I want to copy a table from the production database and paste
it in the test database thus replacing the old copy in the test database.
What's the best way to do it? Thanks in advance.did you hear "=?Utf-8?B?c2hhcm1hbg==?="
<sharman@.discussions.microsoft.com> say in
news:1BFF4909-65DF-41E8-A37C-518BE50D44EC@.microsoft.com:
> I am a newbie. I want to copy a table from the production database and
> paste it in the test database thus replacing the old copy in the test
> database. What's the best way to do it? Thanks in advance.
>
check books online for the Import/Export wizard.
--
Neil MacMurchy
http://spaces.msn.com/members/neilmacmurchy
http://spaces.msn.com/members/mctblogs|||Sharman,
Try the Import/Export Wizard in DTS (Data Transformation Services). See the
SQL Books Online for more information.
HTH
Jerry
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:1BFF4909-65DF-41E8-A37C-518BE50D44EC@.microsoft.com...
> Hi,
> I am a newbie. I want to copy a table from the production database and
> paste
> it in the test database thus replacing the old copy in the test database.
> What's the best way to do it? Thanks in advance.|||Unfortunately, you cannot copy and paste a table from one database to
another. The easiest way to do this is using the DTS Export/Import Wizard.
From the SOURCE database, if you right click the table name, go to ALL
TASKS, then Export Data, it will bring up the wizard.
1) Hit next on the welcome screen.
2) Hit next on the source screen. By starting from the source, you won't
have to enter this information.
3) On the destination screen, enter the server name and choose the
database. You won't have to do anything with the table name at this point.
You just have to tell it where to send the table.
4) The next screen actually has a direct "copy tables..." option, but I
prefer the copy objects and data method, which is the last choice on the
screen. Choose that and click next.
5) You should now be at the "Select Objects to Copy" screen. Here it's
safe to leave the top options, but you MUST uncheck a few and make some
changes at the bottom of the screen. First, UNCHECK BOTH Copy all objects
and Use default options.
6) Hit the "Select Objects" button and mark the table you want to copy.
Then click OK.
7) Now, hit the "Options" button and turn off Copy database users and roles
as well as object-level permissions. You can copy object permissions ONLY if
you have the same database users and roles in the source and destination
databases. If you don't, the copy users and roles choice could help, unless
some of the users or roles already exist.. where it would fail. The easiest
method is to uncheck both of these boxes and reconfigure permissions for the
table once it's copied over.
8) Now hit OK, then next and finish all the way through until your table is
done and copied.
Hope this helps!
Bryan
"sharman" wrote:
> Hi,
> I am a newbie. I want to copy a table from the production database and paste
> it in the test database thus replacing the old copy in the test database.
> What's the best way to do it? Thanks in advance.|||Thanks a lot. I thought there was some easy way like copying and pasting.
"Jerry Spivey" wrote:
> Sharman,
> Try the Import/Export Wizard in DTS (Data Transformation Services). See the
> SQL Books Online for more information.
> HTH
> Jerry
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:1BFF4909-65DF-41E8-A37C-518BE50D44EC@.microsoft.com...
> > Hi,
> >
> > I am a newbie. I want to copy a table from the production database and
> > paste
> > it in the test database thus replacing the old copy in the test database.
> > What's the best way to do it? Thanks in advance.
>
>|||Sharman,
Instead of using DTS you can restore the production backup file on your
test environment.
Erwin
sharman schreef:
> Thanks a lot. I thought there was some easy way like copying and pasting.
> "Jerry Spivey" wrote:
> > Sharman,
> >
> > Try the Import/Export Wizard in DTS (Data Transformation Services). See the
> > SQL Books Online for more information.
> >
> > HTH
> >
> > Jerry
> > "sharman" <sharman@.discussions.microsoft.com> wrote in message
> > news:1BFF4909-65DF-41E8-A37C-518BE50D44EC@.microsoft.com...
> > > Hi,
> > >
> > > I am a newbie. I want to copy a table from the production database and
> > > paste
> > > it in the test database thus replacing the old copy in the test database.
> > > What's the best way to do it? Thanks in advance.
> >
> >
> >
Sunday, March 11, 2012
copying databases from one server (win2K) to another (win2k3)
Hello All,
I am a SQL server newbie, so please try to answer in simple terms. I
am trying to copy databases from a SQL 2000 (Win2k) to another SQL
2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
getting the familiar "Failed to create OMWWIZE share" error.
I've set up my source server to start up with the 'System Account' and
my destination server to start up with my Windows account that has
administrative privileges on that machine.
After reading up on several froums, SQL Server Books online...I came
to know that backup/restore is a wonderful option, but I don't have
the same drive specifications on the two servers and also need some
step by step instructions on how to back up the databases on the
source server and restore the same in the destination server.
Thanks to you all in advance for the help.
Ram.I think that wizard causes more problems than it solves. Have a look at
these:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
Andrew J. Kelly SQL MVP
"RAM GANESAN" <ramganesan@.gmail.com> wrote in message
news:2dca7102.0407301057.445d4d17@.posting.google.com...
> Hello All,
> I am a SQL server newbie, so please try to answer in simple terms. I
> am trying to copy databases from a SQL 2000 (Win2k) to another SQL
> 2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
> getting the familiar "Failed to create OMWWIZE share" error.
> I've set up my source server to start up with the 'System Account' and
> my destination server to start up with my Windows account that has
> administrative privileges on that machine.
> After reading up on several froums, SQL Server Books online...I came
> to know that backup/restore is a wonderful option, but I don't have
> the same drive specifications on the two servers and also need some
> step by step instructions on how to back up the databases on the
> source server and restore the same in the destination server.
> Thanks to you all in advance for the help.
> Ram.|||Easiest way is probably to restore a backup to the other server
or detach/attach
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?kbid=314546
INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/defaul...b;EN-US;q224071
For tips on using the Copy database wizard
INF: Understanding and Troubleshooting the Copy Database Wizard in SQL
Server 2000
http://support.microsoft.com/defaul...b;en-us;Q274463
Also check out
INF: How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/defaul...b;en-us;Q246133
PRB: User Logon and/or Permission Errors After Restoring Dump
http://support.microsoft.com/defaul...b;en-us;Q168001
INF: How to Resolve Permission Issues When a Database is Moved Between SQL
Servers
http://support.microsoft.com/defaul...b;en-us;Q240872
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://support.microsoft.com/defaul...b;en-us;Q274188
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"RAM GANESAN" <ramganesan@.gmail.com> wrote in message
news:2dca7102.0407301057.445d4d17@.posting.google.com...
> Hello All,
> I am a SQL server newbie, so please try to answer in simple terms. I
> am trying to copy databases from a SQL 2000 (Win2k) to another SQL
> 2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
> getting the familiar "Failed to create OMWWIZE share" error.
> I've set up my source server to start up with the 'System Account' and
> my destination server to start up with my Windows account that has
> administrative privileges on that machine.
> After reading up on several froums, SQL Server Books online...I came
> to know that backup/restore is a wonderful option, but I don't have
> the same drive specifications on the two servers and also need some
> step by step instructions on how to back up the databases on the
> source server and restore the same in the destination server.
> Thanks to you all in advance for the help.
> Ram.
I am a SQL server newbie, so please try to answer in simple terms. I
am trying to copy databases from a SQL 2000 (Win2k) to another SQL
2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
getting the familiar "Failed to create OMWWIZE share" error.
I've set up my source server to start up with the 'System Account' and
my destination server to start up with my Windows account that has
administrative privileges on that machine.
After reading up on several froums, SQL Server Books online...I came
to know that backup/restore is a wonderful option, but I don't have
the same drive specifications on the two servers and also need some
step by step instructions on how to back up the databases on the
source server and restore the same in the destination server.
Thanks to you all in advance for the help.
Ram.I think that wizard causes more problems than it solves. Have a look at
these:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
Andrew J. Kelly SQL MVP
"RAM GANESAN" <ramganesan@.gmail.com> wrote in message
news:2dca7102.0407301057.445d4d17@.posting.google.com...
> Hello All,
> I am a SQL server newbie, so please try to answer in simple terms. I
> am trying to copy databases from a SQL 2000 (Win2k) to another SQL
> 2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
> getting the familiar "Failed to create OMWWIZE share" error.
> I've set up my source server to start up with the 'System Account' and
> my destination server to start up with my Windows account that has
> administrative privileges on that machine.
> After reading up on several froums, SQL Server Books online...I came
> to know that backup/restore is a wonderful option, but I don't have
> the same drive specifications on the two servers and also need some
> step by step instructions on how to back up the databases on the
> source server and restore the same in the destination server.
> Thanks to you all in advance for the help.
> Ram.|||Easiest way is probably to restore a backup to the other server
or detach/attach
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?kbid=314546
INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/defaul...b;EN-US;q224071
For tips on using the Copy database wizard
INF: Understanding and Troubleshooting the Copy Database Wizard in SQL
Server 2000
http://support.microsoft.com/defaul...b;en-us;Q274463
Also check out
INF: How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/defaul...b;en-us;Q246133
PRB: User Logon and/or Permission Errors After Restoring Dump
http://support.microsoft.com/defaul...b;en-us;Q168001
INF: How to Resolve Permission Issues When a Database is Moved Between SQL
Servers
http://support.microsoft.com/defaul...b;en-us;Q240872
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://support.microsoft.com/defaul...b;en-us;Q274188
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"RAM GANESAN" <ramganesan@.gmail.com> wrote in message
news:2dca7102.0407301057.445d4d17@.posting.google.com...
> Hello All,
> I am a SQL server newbie, so please try to answer in simple terms. I
> am trying to copy databases from a SQL 2000 (Win2k) to another SQL
> 2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
> getting the familiar "Failed to create OMWWIZE share" error.
> I've set up my source server to start up with the 'System Account' and
> my destination server to start up with my Windows account that has
> administrative privileges on that machine.
> After reading up on several froums, SQL Server Books online...I came
> to know that backup/restore is a wonderful option, but I don't have
> the same drive specifications on the two servers and also need some
> step by step instructions on how to back up the databases on the
> source server and restore the same in the destination server.
> Thanks to you all in advance for the help.
> Ram.
copying databases from one server (win2K) to another (win2k3)
Hello All,
I am a SQL server newbie, so please try to answer in simple terms. I
am trying to copy databases from a SQL 2000 (Win2k) to another SQL
2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
getting the familiar "Failed to create OMWWIZE share" error.
I've set up my source server to start up with the 'System Account' and
my destination server to start up with my Windows account that has
administrative privileges on that machine.
After reading up on several froums, SQL Server Books online...I came
to know that backup/restore is a wonderful option, but I don't have
the same drive specifications on the two servers and also need some
step by step instructions on how to back up the databases on the
source server and restore the same in the destination server.
Thanks to you all in advance for the help.
Ram.I think that wizard causes more problems than it solves. Have a look at
these:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
Andrew J. Kelly SQL MVP
"RAM GANESAN" <ramganesan@.gmail.com> wrote in message
news:2dca7102.0407301057.445d4d17@.posting.google.com...
> Hello All,
> I am a SQL server newbie, so please try to answer in simple terms. I
> am trying to copy databases from a SQL 2000 (Win2k) to another SQL
> 2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
> getting the familiar "Failed to create OMWWIZE share" error.
> I've set up my source server to start up with the 'System Account' and
> my destination server to start up with my Windows account that has
> administrative privileges on that machine.
> After reading up on several froums, SQL Server Books online...I came
> to know that backup/restore is a wonderful option, but I don't have
> the same drive specifications on the two servers and also need some
> step by step instructions on how to back up the databases on the
> source server and restore the same in the destination server.
> Thanks to you all in advance for the help.
> Ram.|||Easiest way is probably to restore a backup to the other server
or detach/attach
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?kbid=314546
INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071
For tips on using the Copy database wizard
INF: Understanding and Troubleshooting the Copy Database Wizard in SQL
Server 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274463
Also check out
INF: How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246133
PRB: User Logon and/or Permission Errors After Restoring Dump
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q168001
INF: How to Resolve Permission Issues When a Database is Moved Between SQL
Servers
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q240872
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274188
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"RAM GANESAN" <ramganesan@.gmail.com> wrote in message
news:2dca7102.0407301057.445d4d17@.posting.google.com...
> Hello All,
> I am a SQL server newbie, so please try to answer in simple terms. I
> am trying to copy databases from a SQL 2000 (Win2k) to another SQL
> 2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
> getting the familiar "Failed to create OMWWIZE share" error.
> I've set up my source server to start up with the 'System Account' and
> my destination server to start up with my Windows account that has
> administrative privileges on that machine.
> After reading up on several froums, SQL Server Books online...I came
> to know that backup/restore is a wonderful option, but I don't have
> the same drive specifications on the two servers and also need some
> step by step instructions on how to back up the databases on the
> source server and restore the same in the destination server.
> Thanks to you all in advance for the help.
> Ram.
I am a SQL server newbie, so please try to answer in simple terms. I
am trying to copy databases from a SQL 2000 (Win2k) to another SQL
2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
getting the familiar "Failed to create OMWWIZE share" error.
I've set up my source server to start up with the 'System Account' and
my destination server to start up with my Windows account that has
administrative privileges on that machine.
After reading up on several froums, SQL Server Books online...I came
to know that backup/restore is a wonderful option, but I don't have
the same drive specifications on the two servers and also need some
step by step instructions on how to back up the databases on the
source server and restore the same in the destination server.
Thanks to you all in advance for the help.
Ram.I think that wizard causes more problems than it solves. Have a look at
these:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
Andrew J. Kelly SQL MVP
"RAM GANESAN" <ramganesan@.gmail.com> wrote in message
news:2dca7102.0407301057.445d4d17@.posting.google.com...
> Hello All,
> I am a SQL server newbie, so please try to answer in simple terms. I
> am trying to copy databases from a SQL 2000 (Win2k) to another SQL
> 2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
> getting the familiar "Failed to create OMWWIZE share" error.
> I've set up my source server to start up with the 'System Account' and
> my destination server to start up with my Windows account that has
> administrative privileges on that machine.
> After reading up on several froums, SQL Server Books online...I came
> to know that backup/restore is a wonderful option, but I don't have
> the same drive specifications on the two servers and also need some
> step by step instructions on how to back up the databases on the
> source server and restore the same in the destination server.
> Thanks to you all in advance for the help.
> Ram.|||Easiest way is probably to restore a backup to the other server
or detach/attach
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?kbid=314546
INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071
For tips on using the Copy database wizard
INF: Understanding and Troubleshooting the Copy Database Wizard in SQL
Server 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274463
Also check out
INF: How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246133
PRB: User Logon and/or Permission Errors After Restoring Dump
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q168001
INF: How to Resolve Permission Issues When a Database is Moved Between SQL
Servers
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q240872
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274188
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"RAM GANESAN" <ramganesan@.gmail.com> wrote in message
news:2dca7102.0407301057.445d4d17@.posting.google.com...
> Hello All,
> I am a SQL server newbie, so please try to answer in simple terms. I
> am trying to copy databases from a SQL 2000 (Win2k) to another SQL
> 2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
> getting the familiar "Failed to create OMWWIZE share" error.
> I've set up my source server to start up with the 'System Account' and
> my destination server to start up with my Windows account that has
> administrative privileges on that machine.
> After reading up on several froums, SQL Server Books online...I came
> to know that backup/restore is a wonderful option, but I don't have
> the same drive specifications on the two servers and also need some
> step by step instructions on how to back up the databases on the
> source server and restore the same in the destination server.
> Thanks to you all in advance for the help.
> Ram.
copying databases from one server (win2K) to another (win2k3)
Hello All,
I am a SQL server newbie, so please try to answer in simple terms. I
am trying to copy databases from a SQL 2000 (Win2k) to another SQL
2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
getting the familiar "Failed to create OMWWIZE share" error.
I've set up my source server to start up with the 'System Account' and
my destination server to start up with my Windows account that has
administrative privileges on that machine.
After reading up on several froums, SQL Server Books online...I came
to know that backup/restore is a wonderful option, but I don't have
the same drive specifications on the two servers and also need some
step by step instructions on how to back up the databases on the
source server and restore the same in the destination server.
Thanks to you all in advance for the help.
Ram.
I think that wizard causes more problems than it solves. Have a look at
these:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
Andrew J. Kelly SQL MVP
"RAM GANESAN" <ramganesan@.gmail.com> wrote in message
news:2dca7102.0407301057.445d4d17@.posting.google.c om...
> Hello All,
> I am a SQL server newbie, so please try to answer in simple terms. I
> am trying to copy databases from a SQL 2000 (Win2k) to another SQL
> 2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
> getting the familiar "Failed to create OMWWIZE share" error.
> I've set up my source server to start up with the 'System Account' and
> my destination server to start up with my Windows account that has
> administrative privileges on that machine.
> After reading up on several froums, SQL Server Books online...I came
> to know that backup/restore is a wonderful option, but I don't have
> the same drive specifications on the two servers and also need some
> step by step instructions on how to back up the databases on the
> source server and restore the same in the destination server.
> Thanks to you all in advance for the help.
> Ram.
|||Easiest way is probably to restore a backup to the other server
or detach/attach
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?kbid=314546
INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/default...;EN-US;q224071
For tips on using the Copy database wizard
INF: Understanding and Troubleshooting the Copy Database Wizard in SQL
Server 2000
http://support.microsoft.com/default...;en-us;Q274463
Also check out
INF: How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/default...;en-us;Q246133
PRB: User Logon and/or Permission Errors After Restoring Dump
http://support.microsoft.com/default...;en-us;Q168001
INF: How to Resolve Permission Issues When a Database is Moved Between SQL
Servers
http://support.microsoft.com/default...;en-us;Q240872
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://support.microsoft.com/default...;en-us;Q274188
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"RAM GANESAN" <ramganesan@.gmail.com> wrote in message
news:2dca7102.0407301057.445d4d17@.posting.google.c om...
> Hello All,
> I am a SQL server newbie, so please try to answer in simple terms. I
> am trying to copy databases from a SQL 2000 (Win2k) to another SQL
> 2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
> getting the familiar "Failed to create OMWWIZE share" error.
> I've set up my source server to start up with the 'System Account' and
> my destination server to start up with my Windows account that has
> administrative privileges on that machine.
> After reading up on several froums, SQL Server Books online...I came
> to know that backup/restore is a wonderful option, but I don't have
> the same drive specifications on the two servers and also need some
> step by step instructions on how to back up the databases on the
> source server and restore the same in the destination server.
> Thanks to you all in advance for the help.
> Ram.
I am a SQL server newbie, so please try to answer in simple terms. I
am trying to copy databases from a SQL 2000 (Win2k) to another SQL
2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
getting the familiar "Failed to create OMWWIZE share" error.
I've set up my source server to start up with the 'System Account' and
my destination server to start up with my Windows account that has
administrative privileges on that machine.
After reading up on several froums, SQL Server Books online...I came
to know that backup/restore is a wonderful option, but I don't have
the same drive specifications on the two servers and also need some
step by step instructions on how to back up the databases on the
source server and restore the same in the destination server.
Thanks to you all in advance for the help.
Ram.
I think that wizard causes more problems than it solves. Have a look at
these:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
Andrew J. Kelly SQL MVP
"RAM GANESAN" <ramganesan@.gmail.com> wrote in message
news:2dca7102.0407301057.445d4d17@.posting.google.c om...
> Hello All,
> I am a SQL server newbie, so please try to answer in simple terms. I
> am trying to copy databases from a SQL 2000 (Win2k) to another SQL
> 2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
> getting the familiar "Failed to create OMWWIZE share" error.
> I've set up my source server to start up with the 'System Account' and
> my destination server to start up with my Windows account that has
> administrative privileges on that machine.
> After reading up on several froums, SQL Server Books online...I came
> to know that backup/restore is a wonderful option, but I don't have
> the same drive specifications on the two servers and also need some
> step by step instructions on how to back up the databases on the
> source server and restore the same in the destination server.
> Thanks to you all in advance for the help.
> Ram.
|||Easiest way is probably to restore a backup to the other server
or detach/attach
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?kbid=314546
INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/default...;EN-US;q224071
For tips on using the Copy database wizard
INF: Understanding and Troubleshooting the Copy Database Wizard in SQL
Server 2000
http://support.microsoft.com/default...;en-us;Q274463
Also check out
INF: How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/default...;en-us;Q246133
PRB: User Logon and/or Permission Errors After Restoring Dump
http://support.microsoft.com/default...;en-us;Q168001
INF: How to Resolve Permission Issues When a Database is Moved Between SQL
Servers
http://support.microsoft.com/default...;en-us;Q240872
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://support.microsoft.com/default...;en-us;Q274188
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"RAM GANESAN" <ramganesan@.gmail.com> wrote in message
news:2dca7102.0407301057.445d4d17@.posting.google.c om...
> Hello All,
> I am a SQL server newbie, so please try to answer in simple terms. I
> am trying to copy databases from a SQL 2000 (Win2k) to another SQL
> 2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
> getting the familiar "Failed to create OMWWIZE share" error.
> I've set up my source server to start up with the 'System Account' and
> my destination server to start up with my Windows account that has
> administrative privileges on that machine.
> After reading up on several froums, SQL Server Books online...I came
> to know that backup/restore is a wonderful option, but I don't have
> the same drive specifications on the two servers and also need some
> step by step instructions on how to back up the databases on the
> source server and restore the same in the destination server.
> Thanks to you all in advance for the help.
> Ram.
Copying database to new name on same server
Dear Y'all -
I'm a newbie to this list. I have a database of about 2Gb that I need
to duplicate several times, giving each duplicate a new name, on to a
single server. Sounds simple is proving to not be so. The basic
export command seems to do what I want but it runs for longer than I'm
willing to wait, over 6 hours. It takes less than an hour to create
the database from scratch.
Is there something I'm missing? Is there a way to duplicate a
database at the file system level and them update the DBMS system
tables (or whatever) so the new files are recognized properly.
TIA.
Yours - Billy
============================================================ William Goedicke goedicke@.goedsole.com
http://www.goedsole.com:8080
============================================================
Lest we forget:
Don't force it; get a bigger hammer.
- Al DodgeDo a backup once, then do multiple restores (during a restore you can
specify a new name, and it will take care of data file names etc. as well).
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"William Goedicke" <wgoedick@.reveregroup.com> wrote in message
news:m38ylcofqg.fsf@.mail.goedsole.com...
> Dear Y'all -
> I'm a newbie to this list. I have a database of about 2Gb that I need
> to duplicate several times, giving each duplicate a new name, on to a
> single server. Sounds simple is proving to not be so. The basic
> export command seems to do what I want but it runs for longer than I'm
> willing to wait, over 6 hours. It takes less than an hour to create
> the database from scratch.
> Is there something I'm missing? Is there a way to duplicate a
> database at the file system level and them update the DBMS system
> tables (or whatever) so the new files are recognized properly.
> TIA.
> Yours - Billy
> ============================================================> William Goedicke goedicke@.goedsole.com
> http://www.goedsole.com:8080
> ============================================================> Lest we forget:
> Don't force it; get a bigger hammer.
> - Al Dodge|||When you do the restores you will need to specify new paths for the data nd
lof files as well. You can do this in Enterprise Manager or use the WITH
MOVE option in Query Analyzer.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||In my last post it should have been:
When you do the restores you will need to specify new paths for the data
and
log files as well. You can do this in Enterprise Manager or use the WITH
MOVE option in Query Analyzer.
This posting is provided "as is" with no warranties and confers no rights.|||If you use EM for the restore, the filenames get changed wrt the new name
automatically, at least in my experience.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Rand Boyd [MS]" <rboyd@.onlinemicrosoft.com> wrote in message
news:rD7WE2KxDHA.3660@.cpmsftngxa07.phx.gbl...
> When you do the restores you will need to specify new paths for the data
nd
> lof files as well. You can do this in Enterprise Manager or use the WITH
> MOVE option in Query Analyzer.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
I'm a newbie to this list. I have a database of about 2Gb that I need
to duplicate several times, giving each duplicate a new name, on to a
single server. Sounds simple is proving to not be so. The basic
export command seems to do what I want but it runs for longer than I'm
willing to wait, over 6 hours. It takes less than an hour to create
the database from scratch.
Is there something I'm missing? Is there a way to duplicate a
database at the file system level and them update the DBMS system
tables (or whatever) so the new files are recognized properly.
TIA.
Yours - Billy
============================================================ William Goedicke goedicke@.goedsole.com
http://www.goedsole.com:8080
============================================================
Lest we forget:
Don't force it; get a bigger hammer.
- Al DodgeDo a backup once, then do multiple restores (during a restore you can
specify a new name, and it will take care of data file names etc. as well).
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"William Goedicke" <wgoedick@.reveregroup.com> wrote in message
news:m38ylcofqg.fsf@.mail.goedsole.com...
> Dear Y'all -
> I'm a newbie to this list. I have a database of about 2Gb that I need
> to duplicate several times, giving each duplicate a new name, on to a
> single server. Sounds simple is proving to not be so. The basic
> export command seems to do what I want but it runs for longer than I'm
> willing to wait, over 6 hours. It takes less than an hour to create
> the database from scratch.
> Is there something I'm missing? Is there a way to duplicate a
> database at the file system level and them update the DBMS system
> tables (or whatever) so the new files are recognized properly.
> TIA.
> Yours - Billy
> ============================================================> William Goedicke goedicke@.goedsole.com
> http://www.goedsole.com:8080
> ============================================================> Lest we forget:
> Don't force it; get a bigger hammer.
> - Al Dodge|||When you do the restores you will need to specify new paths for the data nd
lof files as well. You can do this in Enterprise Manager or use the WITH
MOVE option in Query Analyzer.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||In my last post it should have been:
When you do the restores you will need to specify new paths for the data
and
log files as well. You can do this in Enterprise Manager or use the WITH
MOVE option in Query Analyzer.
This posting is provided "as is" with no warranties and confers no rights.|||If you use EM for the restore, the filenames get changed wrt the new name
automatically, at least in my experience.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Rand Boyd [MS]" <rboyd@.onlinemicrosoft.com> wrote in message
news:rD7WE2KxDHA.3660@.cpmsftngxa07.phx.gbl...
> When you do the restores you will need to specify new paths for the data
nd
> lof files as well. You can do this in Enterprise Manager or use the WITH
> MOVE option in Query Analyzer.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
Thursday, March 8, 2012
Copying Data From One DataBase To Another?
Yet another very much newbie question I suspect….
I want to know how I copy data from one field in one
DataBase to another field in another DataBase?
Basically I have an ASP driven forum, and want to upgrade to
a new ASP.NET forum… Problem is obviously the DataBase structure is different
and I don’t want to loose all the data from my current forum…So I would have to pick which table field
needs to be copied to where in the new DataBase..
Is this easy to do?
I will be using SQLExpress 2005?
Thanks
You can use a statement with a three-part name:INSERT INTO YourTable
( ColumnsHere)
SELECT ColumnsFromtheOtherDb here
FROM Databasename.SchemaName.TableName
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
copying Data Base from one sever to another
Hi,
Hope I explain this clearly. I'm a newbie to sql. I currently have 2
servers running sql 2000. One is a Production and the other a test server. On
the test server I have a duplicate sql 2000 with a copy of the database from
the production server. Which all are working fine. Both systems have a tape
drive. It's a very old D.B. copy on the test server so I would like to copy a
newer one over from the Prod. server. The tape drive on the production server
is a newer drive than the one on the test server. So I'm unable to restore
from the Prod. to the test server via tape. I would not like to stop sql
running on the prod. server. Is the a way to load the tape in the Prod server
and restore it to the test server? -- I only need the D.B. copyed. I would
not want to detach the D.B.
GregHi
This sounds like an access issue rather than anything else! If you have disk
space on the production server for a backup to disk, you may then be able to
either use a network share/FTP... etc to move it to the production system.
Failing that maybe a removable disk (but then there is a risk when
introducing new hardware!).
HTH
John
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:ECC06AC5-7FB7-423E-A023-71A3F0D8C102@.microsoft.com...
> Hi,
> Hope I explain this clearly. I'm a newbie to sql. I currently have 2
> servers running sql 2000. One is a Production and the other a test server.
> On
> the test server I have a duplicate sql 2000 with a copy of the database
> from
> the production server. Which all are working fine. Both systems have a
> tape
> drive. It's a very old D.B. copy on the test server so I would like to
> copy a
> newer one over from the Prod. server. The tape drive on the production
> server
> is a newer drive than the one on the test server. So I'm unable to restore
> from the Prod. to the test server via tape. I would not like to stop sql
> running on the prod. server. Is the a way to load the tape in the Prod
> server
> and restore it to the test server? -- I only need the D.B. copyed. I would
> not want to detach the D.B.
> Greg|||Depends what you have available.
Can you transfer anything between the prod and test server? If not then
obviously you can't refresh.
If you can transfer data then backup the prod database copy the backup to
the test server (via tape if necessary) and restore it.
If you can't do that much then you probably need to spend some time getting
into a situation where you can.
"Greg" wrote:
> Hi,
> Hope I explain this clearly. I'm a newbie to sql. I currently have 2
> servers running sql 2000. One is a Production and the other a test server. On
> the test server I have a duplicate sql 2000 with a copy of the database from
> the production server. Which all are working fine. Both systems have a tape
> drive. It's a very old D.B. copy on the test server so I would like to copy a
> newer one over from the Prod. server. The tape drive on the production server
> is a newer drive than the one on the test server. So I'm unable to restore
> from the Prod. to the test server via tape. I would not like to stop sql
> running on the prod. server. Is the a way to load the tape in the Prod server
> and restore it to the test server? -- I only need the D.B. copyed. I would
> not want to detach the D.B.
> Greg
Hope I explain this clearly. I'm a newbie to sql. I currently have 2
servers running sql 2000. One is a Production and the other a test server. On
the test server I have a duplicate sql 2000 with a copy of the database from
the production server. Which all are working fine. Both systems have a tape
drive. It's a very old D.B. copy on the test server so I would like to copy a
newer one over from the Prod. server. The tape drive on the production server
is a newer drive than the one on the test server. So I'm unable to restore
from the Prod. to the test server via tape. I would not like to stop sql
running on the prod. server. Is the a way to load the tape in the Prod server
and restore it to the test server? -- I only need the D.B. copyed. I would
not want to detach the D.B.
GregHi
This sounds like an access issue rather than anything else! If you have disk
space on the production server for a backup to disk, you may then be able to
either use a network share/FTP... etc to move it to the production system.
Failing that maybe a removable disk (but then there is a risk when
introducing new hardware!).
HTH
John
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:ECC06AC5-7FB7-423E-A023-71A3F0D8C102@.microsoft.com...
> Hi,
> Hope I explain this clearly. I'm a newbie to sql. I currently have 2
> servers running sql 2000. One is a Production and the other a test server.
> On
> the test server I have a duplicate sql 2000 with a copy of the database
> from
> the production server. Which all are working fine. Both systems have a
> tape
> drive. It's a very old D.B. copy on the test server so I would like to
> copy a
> newer one over from the Prod. server. The tape drive on the production
> server
> is a newer drive than the one on the test server. So I'm unable to restore
> from the Prod. to the test server via tape. I would not like to stop sql
> running on the prod. server. Is the a way to load the tape in the Prod
> server
> and restore it to the test server? -- I only need the D.B. copyed. I would
> not want to detach the D.B.
> Greg|||Depends what you have available.
Can you transfer anything between the prod and test server? If not then
obviously you can't refresh.
If you can transfer data then backup the prod database copy the backup to
the test server (via tape if necessary) and restore it.
If you can't do that much then you probably need to spend some time getting
into a situation where you can.
"Greg" wrote:
> Hi,
> Hope I explain this clearly. I'm a newbie to sql. I currently have 2
> servers running sql 2000. One is a Production and the other a test server. On
> the test server I have a duplicate sql 2000 with a copy of the database from
> the production server. Which all are working fine. Both systems have a tape
> drive. It's a very old D.B. copy on the test server so I would like to copy a
> newer one over from the Prod. server. The tape drive on the production server
> is a newer drive than the one on the test server. So I'm unable to restore
> from the Prod. to the test server via tape. I would not like to stop sql
> running on the prod. server. Is the a way to load the tape in the Prod server
> and restore it to the test server? -- I only need the D.B. copyed. I would
> not want to detach the D.B.
> Greg
copying Data Base from one sever to another
Hi,
Hope I explain this clearly. I'm a newbie to sql. I currently have 2
servers running sql 2000. One is a Production and the other a test server. O
n
the test server I have a duplicate sql 2000 with a copy of the database from
the production server. Which all are working fine. Both systems have a tape
drive. It's a very old D.B. copy on the test server so I would like to copy
a
newer one over from the Prod. server. The tape drive on the production serve
r
is a newer drive than the one on the test server. So I'm unable to restore
from the Prod. to the test server via tape. I would not like to stop sql
running on the prod. server. Is the a way to load the tape in the Prod serve
r
and restore it to the test server? -- I only need the D.B. copyed. I would
not want to detach the D.B.
GregHi
This sounds like an access issue rather than anything else! If you have disk
space on the production server for a backup to disk, you may then be able to
either use a network share/FTP... etc to move it to the production system.
Failing that maybe a removable disk (but then there is a risk when
introducing new hardware!).
HTH
John
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:ECC06AC5-7FB7-423E-A023-71A3F0D8C102@.microsoft.com...
> Hi,
> Hope I explain this clearly. I'm a newbie to sql. I currently have 2
> servers running sql 2000. One is a Production and the other a test server.
> On
> the test server I have a duplicate sql 2000 with a copy of the database
> from
> the production server. Which all are working fine. Both systems have a
> tape
> drive. It's a very old D.B. copy on the test server so I would like to
> copy a
> newer one over from the Prod. server. The tape drive on the production
> server
> is a newer drive than the one on the test server. So I'm unable to restore
> from the Prod. to the test server via tape. I would not like to stop sql
> running on the prod. server. Is the a way to load the tape in the Prod
> server
> and restore it to the test server? -- I only need the D.B. copyed. I would
> not want to detach the D.B.
> Greg|||Depends what you have available.
Can you transfer anything between the prod and test server? If not then
obviously you can't refresh.
If you can transfer data then backup the prod database copy the backup to
the test server (via tape if necessary) and restore it.
If you can't do that much then you probably need to spend some time getting
into a situation where you can.
"Greg" wrote:
> Hi,
> Hope I explain this clearly. I'm a newbie to sql. I currently have 2
> servers running sql 2000. One is a Production and the other a test server.
On
> the test server I have a duplicate sql 2000 with a copy of the database fr
om
> the production server. Which all are working fine. Both systems have a tap
e
> drive. It's a very old D.B. copy on the test server so I would like to cop
y a
> newer one over from the Prod. server. The tape drive on the production ser
ver
> is a newer drive than the one on the test server. So I'm unable to restore
> from the Prod. to the test server via tape. I would not like to stop sql
> running on the prod. server. Is the a way to load the tape in the Prod ser
ver
> and restore it to the test server? -- I only need the D.B. copyed. I would
> not want to detach the D.B.
> Greg
Hope I explain this clearly. I'm a newbie to sql. I currently have 2
servers running sql 2000. One is a Production and the other a test server. O
n
the test server I have a duplicate sql 2000 with a copy of the database from
the production server. Which all are working fine. Both systems have a tape
drive. It's a very old D.B. copy on the test server so I would like to copy
a
newer one over from the Prod. server. The tape drive on the production serve
r
is a newer drive than the one on the test server. So I'm unable to restore
from the Prod. to the test server via tape. I would not like to stop sql
running on the prod. server. Is the a way to load the tape in the Prod serve
r
and restore it to the test server? -- I only need the D.B. copyed. I would
not want to detach the D.B.
GregHi
This sounds like an access issue rather than anything else! If you have disk
space on the production server for a backup to disk, you may then be able to
either use a network share/FTP... etc to move it to the production system.
Failing that maybe a removable disk (but then there is a risk when
introducing new hardware!).
HTH
John
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:ECC06AC5-7FB7-423E-A023-71A3F0D8C102@.microsoft.com...
> Hi,
> Hope I explain this clearly. I'm a newbie to sql. I currently have 2
> servers running sql 2000. One is a Production and the other a test server.
> On
> the test server I have a duplicate sql 2000 with a copy of the database
> from
> the production server. Which all are working fine. Both systems have a
> tape
> drive. It's a very old D.B. copy on the test server so I would like to
> copy a
> newer one over from the Prod. server. The tape drive on the production
> server
> is a newer drive than the one on the test server. So I'm unable to restore
> from the Prod. to the test server via tape. I would not like to stop sql
> running on the prod. server. Is the a way to load the tape in the Prod
> server
> and restore it to the test server? -- I only need the D.B. copyed. I would
> not want to detach the D.B.
> Greg|||Depends what you have available.
Can you transfer anything between the prod and test server? If not then
obviously you can't refresh.
If you can transfer data then backup the prod database copy the backup to
the test server (via tape if necessary) and restore it.
If you can't do that much then you probably need to spend some time getting
into a situation where you can.
"Greg" wrote:
> Hi,
> Hope I explain this clearly. I'm a newbie to sql. I currently have 2
> servers running sql 2000. One is a Production and the other a test server.
On
> the test server I have a duplicate sql 2000 with a copy of the database fr
om
> the production server. Which all are working fine. Both systems have a tap
e
> drive. It's a very old D.B. copy on the test server so I would like to cop
y a
> newer one over from the Prod. server. The tape drive on the production ser
ver
> is a newer drive than the one on the test server. So I'm unable to restore
> from the Prod. to the test server via tape. I would not like to stop sql
> running on the prod. server. Is the a way to load the tape in the Prod ser
ver
> and restore it to the test server? -- I only need the D.B. copyed. I would
> not want to detach the D.B.
> Greg
copying Data Base from one sever to another
Hi,
Hope I explain this clearly. I'm a newbie to sql. I currently have 2
servers running sql 2000. One is a Production and the other a test server. On
the test server I have a duplicate sql 2000 with a copy of the database from
the production server. Which all are working fine. Both systems have a tape
drive. It's a very old D.B. copy on the test server so I would like to copy a
newer one over from the Prod. server. The tape drive on the production server
is a newer drive than the one on the test server. So I'm unable to restore
from the Prod. to the test server via tape. I would not like to stop sql
running on the prod. server. Is the a way to load the tape in the Prod server
and restore it to the test server? -- I only need the D.B. copyed. I would
not want to detach the D.B.
Greg
Hi
This sounds like an access issue rather than anything else! If you have disk
space on the production server for a backup to disk, you may then be able to
either use a network share/FTP... etc to move it to the production system.
Failing that maybe a removable disk (but then there is a risk when
introducing new hardware!).
HTH
John
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:ECC06AC5-7FB7-423E-A023-71A3F0D8C102@.microsoft.com...
> Hi,
> Hope I explain this clearly. I'm a newbie to sql. I currently have 2
> servers running sql 2000. One is a Production and the other a test server.
> On
> the test server I have a duplicate sql 2000 with a copy of the database
> from
> the production server. Which all are working fine. Both systems have a
> tape
> drive. It's a very old D.B. copy on the test server so I would like to
> copy a
> newer one over from the Prod. server. The tape drive on the production
> server
> is a newer drive than the one on the test server. So I'm unable to restore
> from the Prod. to the test server via tape. I would not like to stop sql
> running on the prod. server. Is the a way to load the tape in the Prod
> server
> and restore it to the test server? -- I only need the D.B. copyed. I would
> not want to detach the D.B.
> Greg
|||Depends what you have available.
Can you transfer anything between the prod and test server? If not then
obviously you can't refresh.
If you can transfer data then backup the prod database copy the backup to
the test server (via tape if necessary) and restore it.
If you can't do that much then you probably need to spend some time getting
into a situation where you can.
"Greg" wrote:
> Hi,
> Hope I explain this clearly. I'm a newbie to sql. I currently have 2
> servers running sql 2000. One is a Production and the other a test server. On
> the test server I have a duplicate sql 2000 with a copy of the database from
> the production server. Which all are working fine. Both systems have a tape
> drive. It's a very old D.B. copy on the test server so I would like to copy a
> newer one over from the Prod. server. The tape drive on the production server
> is a newer drive than the one on the test server. So I'm unable to restore
> from the Prod. to the test server via tape. I would not like to stop sql
> running on the prod. server. Is the a way to load the tape in the Prod server
> and restore it to the test server? -- I only need the D.B. copyed. I would
> not want to detach the D.B.
> Greg
Hope I explain this clearly. I'm a newbie to sql. I currently have 2
servers running sql 2000. One is a Production and the other a test server. On
the test server I have a duplicate sql 2000 with a copy of the database from
the production server. Which all are working fine. Both systems have a tape
drive. It's a very old D.B. copy on the test server so I would like to copy a
newer one over from the Prod. server. The tape drive on the production server
is a newer drive than the one on the test server. So I'm unable to restore
from the Prod. to the test server via tape. I would not like to stop sql
running on the prod. server. Is the a way to load the tape in the Prod server
and restore it to the test server? -- I only need the D.B. copyed. I would
not want to detach the D.B.
Greg
Hi
This sounds like an access issue rather than anything else! If you have disk
space on the production server for a backup to disk, you may then be able to
either use a network share/FTP... etc to move it to the production system.
Failing that maybe a removable disk (but then there is a risk when
introducing new hardware!).
HTH
John
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:ECC06AC5-7FB7-423E-A023-71A3F0D8C102@.microsoft.com...
> Hi,
> Hope I explain this clearly. I'm a newbie to sql. I currently have 2
> servers running sql 2000. One is a Production and the other a test server.
> On
> the test server I have a duplicate sql 2000 with a copy of the database
> from
> the production server. Which all are working fine. Both systems have a
> tape
> drive. It's a very old D.B. copy on the test server so I would like to
> copy a
> newer one over from the Prod. server. The tape drive on the production
> server
> is a newer drive than the one on the test server. So I'm unable to restore
> from the Prod. to the test server via tape. I would not like to stop sql
> running on the prod. server. Is the a way to load the tape in the Prod
> server
> and restore it to the test server? -- I only need the D.B. copyed. I would
> not want to detach the D.B.
> Greg
|||Depends what you have available.
Can you transfer anything between the prod and test server? If not then
obviously you can't refresh.
If you can transfer data then backup the prod database copy the backup to
the test server (via tape if necessary) and restore it.
If you can't do that much then you probably need to spend some time getting
into a situation where you can.
"Greg" wrote:
> Hi,
> Hope I explain this clearly. I'm a newbie to sql. I currently have 2
> servers running sql 2000. One is a Production and the other a test server. On
> the test server I have a duplicate sql 2000 with a copy of the database from
> the production server. Which all are working fine. Both systems have a tape
> drive. It's a very old D.B. copy on the test server so I would like to copy a
> newer one over from the Prod. server. The tape drive on the production server
> is a newer drive than the one on the test server. So I'm unable to restore
> from the Prod. to the test server via tape. I would not like to stop sql
> running on the prod. server. Is the a way to load the tape in the Prod server
> and restore it to the test server? -- I only need the D.B. copyed. I would
> not want to detach the D.B.
> Greg
Wednesday, March 7, 2012
Copying a subset from SQL Server
Newbie question: (apologies all)
How does one download a subset from server to notebook?
Practical problem: Executive visiting customer wants database on customer.
Sharepoint and Project 2003 data.
Thank you
Brent Rowell
"Brent Rowell" <anonymous@.discussions.microsoft.com> wrote in message
news:D4B70D84-AA6E-4B1E-929C-C9F7C770B84B@.microsoft.com...
> Newbie question: (apologies all)
> How does one download a subset from server to notebook?
> Practical problem: Executive visiting customer wants database on customer.
> Sharepoint and Project 2003 data.
Once you've got MSDE installed on the laptop, you could use Enterprise
Manager and DTS to transfer the data subset you need from the server to the
notebook...
Steve
|||Thank you
Brent
"Steve Thompson" <SteveThompson@.nomail.please> wrote in message
news:O0WrUcMIEHA.828@.TK2MSFTNGP12.phx.gbl...
> "Brent Rowell" <anonymous@.discussions.microsoft.com> wrote in message
> news:D4B70D84-AA6E-4B1E-929C-C9F7C770B84B@.microsoft.com...
customer.
> Once you've got MSDE installed on the laptop, you could use Enterprise
> Manager and DTS to transfer the data subset you need from the server to
the
> notebook...
> Steve
>
|||"Brent Rowell" <brent@.pls_remove_jrowell.com> wrote in message news:<eEYV2wPIEHA.3200@.TK2MSFTNGP10.phx.gbl>...[vbcol=seagreen]
> Thank you
> Brent
> "Steve Thompson" <SteveThompson@.nomail.please> wrote in message
> news:O0WrUcMIEHA.828@.TK2MSFTNGP12.phx.gbl...
> customer.
> the
You could use Super*SQL to create an ASCII file containing all of the
database tables, then copy the file to the notebook and load into the
local database. I found the Beta version at www.sqlmagic.com.
How does one download a subset from server to notebook?
Practical problem: Executive visiting customer wants database on customer.
Sharepoint and Project 2003 data.
Thank you
Brent Rowell
"Brent Rowell" <anonymous@.discussions.microsoft.com> wrote in message
news:D4B70D84-AA6E-4B1E-929C-C9F7C770B84B@.microsoft.com...
> Newbie question: (apologies all)
> How does one download a subset from server to notebook?
> Practical problem: Executive visiting customer wants database on customer.
> Sharepoint and Project 2003 data.
Once you've got MSDE installed on the laptop, you could use Enterprise
Manager and DTS to transfer the data subset you need from the server to the
notebook...
Steve
|||Thank you
Brent
"Steve Thompson" <SteveThompson@.nomail.please> wrote in message
news:O0WrUcMIEHA.828@.TK2MSFTNGP12.phx.gbl...
> "Brent Rowell" <anonymous@.discussions.microsoft.com> wrote in message
> news:D4B70D84-AA6E-4B1E-929C-C9F7C770B84B@.microsoft.com...
customer.
> Once you've got MSDE installed on the laptop, you could use Enterprise
> Manager and DTS to transfer the data subset you need from the server to
the
> notebook...
> Steve
>
|||"Brent Rowell" <brent@.pls_remove_jrowell.com> wrote in message news:<eEYV2wPIEHA.3200@.TK2MSFTNGP10.phx.gbl>...[vbcol=seagreen]
> Thank you
> Brent
> "Steve Thompson" <SteveThompson@.nomail.please> wrote in message
> news:O0WrUcMIEHA.828@.TK2MSFTNGP12.phx.gbl...
> customer.
> the
You could use Super*SQL to create an ASCII file containing all of the
database tables, then copy the file to the notebook and load into the
local database. I found the Beta version at www.sqlmagic.com.
Monday, February 13, 2012
Copy schema and data from sqls2k to sqls2k5express
Hello,
I am a newbie on this subject.
How do I move a database in SQL Server 2000 to SQL Server 2005 Express?
How do I manage SQL Server 2005 Express? Can that be done in VS 2005
Professional.
Thank you,
dbuchananHi
Backup and restore or DB attach and detach.
You can use Microsoft SQL Server Management Studio Express - Community
Technology Preview (CTP) November 2005 to manage the SQL Express instance.
http://www.microsoft.com/downloads/...&displaylang=en
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"dbuchanan" <dbuchanan52@.hotmail.com> wrote in message
news:1134435181.280719.206900@.g49g2000cwa.googlegroups.com...
> Hello,
> I am a newbie on this subject.
> How do I move a database in SQL Server 2000 to SQL Server 2005 Express?
> How do I manage SQL Server 2005 Express? Can that be done in VS 2005
> Professional.
> Thank you,
> dbuchanan
>|||Mike,
My previous question I asked for my target machine.
I have MSDN Professional subscription and I have SQL Server 2005
installed, but I don't know how to get started with 2005
1.) Where are the databases. I selected the option to install all
sample databases.
2.) Where also is the equivalent to Enterprise Manager, Query Analyser
for 2005 and the other services. I did a complete install!
Under SQL Configuration Manager / SQL Server 2005 Services I can see a
list of everything I would be interested in finding. I can see the
state, start mode, etc. of these services but where to I get access to
them'''?
How do I get started with SQL Server 2005? Does it have to be made into
such a mystery'
Thank you,
dbuchanan|||The new weapon of choice is the SQL Server Management Studio (SSMS). And whe
n
I say 'choice' one really has no other choice. :)
But you might start with the SQL Server Cofiguration Manager and the SQL
Server Surface Area Configuration to enable access to the server, or better
yet - Books Online, What's new.
ML
http://milambda.blogspot.com/|||ML,
1.) I did a full install. Does SQL Server Management Studio install
with SQL Server 2005? I cannot find it.
2.) Where is Books Online? The Icon that looks like it from SQL Server
Configuration Manager is really MMC help and a search of "What's New"
says nothing about SQL Server 2005.
The Help from SQL Server 2005 Serface Area Configuration is SQL Server
Setup help and a search of "What's New" is whats net for setup.
For SQL Server 2005 from the start menu there is no shortcut to Books
Online like there is for SQL Server 2000.
Where is Books Online?
Why is SQL Server 2005 services so hard to find?
dbuchanan|||Are you using SQL 2005 Express? Well, there are no visual tools available in
the SQL Express set up. SQL Server Management Studio Express is available as
a separate download. The same goes for Books Online.
Go to http://www.microsoft.com/downloads
Help (Books Online) is also avaliable on-line:
http://msdn2.microsoft.com/default.aspx
ML
http://milambda.blogspot.com/|||ML,
No I am not using SQL 2005 Express.
I have done a *complete* install of *SQL Server 2005 Developer
Edition*. I am a MSDN *Professional* Subscriber.
Where is Books Online? Were are the SQL Server Management Studio?
dbuchanan|||
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Backup and restore or DB attach and detach.
>
I have tried to do this. SQL2005 Express does not support these featurs for
SQL 2000 databases. If you are sucessful please let us all know! I would
like to distribute a SQL2000 database to clients running SQL2005 express.
After much research I am still trying to get the database into SQL2005
Express. Any help would be very much appreciated!|||> If you are sucessful please let us all know!
I detached a SQL 2000 database using sp_detach_db and successfully attached
the files to a SQL 2005 with CREATE DATABASE ... FOR ATTACH:
CREATE DATABASE MyDatabase
ON(
NAME='MyDatabase',
FILENAME='C:\DataFiles\MyDatabase_Data.mdf')
LOG ON(
NAME='MyDatabase_Log',
FILENAME='C:\LogFiles\MyDatabase_Log.ldf')
FOR ATTACH
Hope this helps.
Dan Guzman
SQL Server MVP
"HVG" <HVG@.discussions.microsoft.com> wrote in message
news:D5F8E749-D268-4B4D-870E-7B7089195D82@.microsoft.com...
>
> "Mike Epprecht (SQL MVP)" wrote:
>
> I have tried to do this. SQL2005 Express does not support these featurs
> for
> SQL 2000 databases. If you are sucessful please let us all know! I would
> like to distribute a SQL2000 database to clients running SQL2005 express.
> After much research I am still trying to get the database into SQL2005
> Express. Any help would be very much appreciated!
I am a newbie on this subject.
How do I move a database in SQL Server 2000 to SQL Server 2005 Express?
How do I manage SQL Server 2005 Express? Can that be done in VS 2005
Professional.
Thank you,
dbuchananHi
Backup and restore or DB attach and detach.
You can use Microsoft SQL Server Management Studio Express - Community
Technology Preview (CTP) November 2005 to manage the SQL Express instance.
http://www.microsoft.com/downloads/...&displaylang=en
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"dbuchanan" <dbuchanan52@.hotmail.com> wrote in message
news:1134435181.280719.206900@.g49g2000cwa.googlegroups.com...
> Hello,
> I am a newbie on this subject.
> How do I move a database in SQL Server 2000 to SQL Server 2005 Express?
> How do I manage SQL Server 2005 Express? Can that be done in VS 2005
> Professional.
> Thank you,
> dbuchanan
>|||Mike,
My previous question I asked for my target machine.
I have MSDN Professional subscription and I have SQL Server 2005
installed, but I don't know how to get started with 2005
1.) Where are the databases. I selected the option to install all
sample databases.
2.) Where also is the equivalent to Enterprise Manager, Query Analyser
for 2005 and the other services. I did a complete install!
Under SQL Configuration Manager / SQL Server 2005 Services I can see a
list of everything I would be interested in finding. I can see the
state, start mode, etc. of these services but where to I get access to
them'''?
How do I get started with SQL Server 2005? Does it have to be made into
such a mystery'
Thank you,
dbuchanan|||The new weapon of choice is the SQL Server Management Studio (SSMS). And whe
n
I say 'choice' one really has no other choice. :)
But you might start with the SQL Server Cofiguration Manager and the SQL
Server Surface Area Configuration to enable access to the server, or better
yet - Books Online, What's new.
ML
http://milambda.blogspot.com/|||ML,
1.) I did a full install. Does SQL Server Management Studio install
with SQL Server 2005? I cannot find it.
2.) Where is Books Online? The Icon that looks like it from SQL Server
Configuration Manager is really MMC help and a search of "What's New"
says nothing about SQL Server 2005.
The Help from SQL Server 2005 Serface Area Configuration is SQL Server
Setup help and a search of "What's New" is whats net for setup.
For SQL Server 2005 from the start menu there is no shortcut to Books
Online like there is for SQL Server 2000.
Where is Books Online?
Why is SQL Server 2005 services so hard to find?
dbuchanan|||Are you using SQL 2005 Express? Well, there are no visual tools available in
the SQL Express set up. SQL Server Management Studio Express is available as
a separate download. The same goes for Books Online.
Go to http://www.microsoft.com/downloads
Help (Books Online) is also avaliable on-line:
http://msdn2.microsoft.com/default.aspx
ML
http://milambda.blogspot.com/|||ML,
No I am not using SQL 2005 Express.
I have done a *complete* install of *SQL Server 2005 Developer
Edition*. I am a MSDN *Professional* Subscriber.
Where is Books Online? Were are the SQL Server Management Studio?
dbuchanan|||
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Backup and restore or DB attach and detach.
>
I have tried to do this. SQL2005 Express does not support these featurs for
SQL 2000 databases. If you are sucessful please let us all know! I would
like to distribute a SQL2000 database to clients running SQL2005 express.
After much research I am still trying to get the database into SQL2005
Express. Any help would be very much appreciated!|||> If you are sucessful please let us all know!
I detached a SQL 2000 database using sp_detach_db and successfully attached
the files to a SQL 2005 with CREATE DATABASE ... FOR ATTACH:
CREATE DATABASE MyDatabase
ON(
NAME='MyDatabase',
FILENAME='C:\DataFiles\MyDatabase_Data.mdf')
LOG ON(
NAME='MyDatabase_Log',
FILENAME='C:\LogFiles\MyDatabase_Log.ldf')
FOR ATTACH
Hope this helps.
Dan Guzman
SQL Server MVP
"HVG" <HVG@.discussions.microsoft.com> wrote in message
news:D5F8E749-D268-4B4D-870E-7B7089195D82@.microsoft.com...
>
> "Mike Epprecht (SQL MVP)" wrote:
>
> I have tried to do this. SQL2005 Express does not support these featurs
> for
> SQL 2000 databases. If you are sucessful please let us all know! I would
> like to distribute a SQL2000 database to clients running SQL2005 express.
> After much research I am still trying to get the database into SQL2005
> Express. Any help would be very much appreciated!
Subscribe to:
Posts (Atom)