Export SQL database (all tables) from remote server
up vote
0
down vote
favorite
I'm current using a 3rd party product, which uses an SQL Server database. I've been asked to take a copy of the database for our own backup/security purposes, but I'm having trouble.
To access the database I'm currently logging into one of my companies servers using remote desktop, where SQL Server 2005 Express is installed. Using that instance of SQL Server I then connect to the 3rd party's SQL server.
when I execute Tasks -> Back Up..., it appears to work, but the files are stored locally on the remote SQL Databases server, which my IT teams tells me is expected.
I tried using Tasks -> Generate Scripts... but the option to "Script Data" isn't available, either because it's SQL Server 2005 Express, or because the database is remote (not sure which, but probably one of those).
I've tried other things that I can't recall at the moment, and I'm out of ideas.
Can anyone suggest something that will let me get a 'local' copy of the remote databases table structure AND data?
sql database-backups sql-server-2005-express
asked Feb 11 '13 at 13:27
QMKevin
5463925
add a comment |
up vote
0
down vote
favorite
I'm current using a 3rd party product, which uses an SQL Server database. I've been asked to take a copy of the database for our own backup/security purposes, but I'm having trouble.
To access the database I'm currently logging into one of my companies servers using remote desktop, where SQL Server 2005 Express is installed. Using that instance of SQL Server I then connect to the 3rd party's SQL server.
when I execute Tasks -> Back Up..., it appears to work, but the files are stored locally on the remote SQL Databases server, which my IT teams tells me is expected.
I tried using Tasks -> Generate Scripts... but the option to "Script Data" isn't available, either because it's SQL Server 2005 Express, or because the database is remote (not sure which, but probably one of those).
I've tried other things that I can't recall at the moment, and I'm out of ideas.
Can anyone suggest something that will let me get a 'local' copy of the remote databases table structure AND data?
sql database-backups sql-server-2005-express
asked Feb 11 '13 at 13:27
QMKevin
5463925
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I'm current using a 3rd party product, which uses an SQL Server database. I've been asked to take a copy of the database for our own backup/security purposes, but I'm having trouble.
To access the database I'm currently logging into one of my companies servers using remote desktop, where SQL Server 2005 Express is installed. Using that instance of SQL Server I then connect to the 3rd party's SQL server.
when I execute Tasks -> Back Up..., it appears to work, but the files are stored locally on the remote SQL Databases server, which my IT teams tells me is expected.
I tried using Tasks -> Generate Scripts... but the option to "Script Data" isn't available, either because it's SQL Server 2005 Express, or because the database is remote (not sure which, but probably one of those).
I've tried other things that I can't recall at the moment, and I'm out of ideas.
Can anyone suggest something that will let me get a 'local' copy of the remote databases table structure AND data?
sql database-backups sql-server-2005-express
asked Feb 11 '13 at 13:27
QMKevin
5463925
I'm current using a 3rd party product, which uses an SQL Server database. I've been asked to take a copy of the database for our own backup/security purposes, but I'm having trouble.
To access the database I'm currently logging into one of my companies servers using remote desktop, where SQL Server 2005 Express is installed. Using that instance of SQL Server I then connect to the 3rd party's SQL server.
when I execute Tasks -> Back Up..., it appears to work, but the files are stored locally on the remote SQL Databases server, which my IT teams tells me is expected.
I tried using Tasks -> Generate Scripts... but the option to "Script Data" isn't available, either because it's SQL Server 2005 Express, or because the database is remote (not sure which, but probably one of those).
I've tried other things that I can't recall at the moment, and I'm out of ideas.
Can anyone suggest something that will let me get a 'local' copy of the remote databases table structure AND data?
sql database-backups sql-server-2005-express
sql database-backups sql-server-2005-express
asked Feb 11 '13 at 13:27
QMKevin
5463925
asked Feb 11 '13 at 13:27
QMKevin
5463925
asked Feb 11 '13 at 13:27
QMKevin
5463925
asked Feb 11 '13 at 13:27
QMKevin
5463925
asked Feb 11 '13 at 13:27
QMKevin
5463925
5463925
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
up vote
2
down vote
accepted
The Generate Scripts wizard is unavailable because you are using a very old version of Management Studio Express. The 2012 version will work just fine against 2005 instances, but there is no longer an Express edition anyway, because all of the SSMS features are now available without any license.
Download the latest versions here:
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
I list downloads for the older versions at the bottom of this post:
https://blogs.sentryone.com/team-posts/latest-builds-management-studio/
answered Feb 11 '13 at 13:31
Aaron Bertrand
205k27357401
I selected this as the answer. I used 2005 as this is what was available on the server. However, I did install 2008 locally (not express) and the option to download structure AND data is available, and currently running. Cheers
– QMKevin
Feb 11 '13 at 19:38
add a comment |
up vote
1
down vote
Backups do generate locally. That is to be expected, as your team has already told you. You can generate it locally and then download it with a tool such as an FTP client. I highly recommend Redgate tools. See http://www.red-gate.com/products/dba/sql-backup/ It's a great tool and has some network backup options built in to ship your backups elsewhere. If it's a one-time thing, Redgate also has tools for that too, e.g. SQL Compare and SQL Data Compare.
The solution you pick really depends on how frequently you have to run and download backups locally and how big the DB is.
answered Feb 11 '13 at 13:32
Eli Gassert
8,57621935
Unfortuantely I have no access to the DB Server, so cannot get teh file once it's downloaded. Neither do I have info on the network used by the 3rd party, so I cannot save the file via the network to an FTP site. This is a one-time deal, so Aaron's solution works best for me. Thanks though
– QMKevin
Feb 11 '13 at 19:37
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
2
down vote
accepted
The Generate Scripts wizard is unavailable because you are using a very old version of Management Studio Express. The 2012 version will work just fine against 2005 instances, but there is no longer an Express edition anyway, because all of the SSMS features are now available without any license.
Download the latest versions here:
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
I list downloads for the older versions at the bottom of this post:
https://blogs.sentryone.com/team-posts/latest-builds-management-studio/
answered Feb 11 '13 at 13:31
Aaron Bertrand
205k27357401
I selected this as the answer. I used 2005 as this is what was available on the server. However, I did install 2008 locally (not express) and the option to download structure AND data is available, and currently running. Cheers
– QMKevin
Feb 11 '13 at 19:38
add a comment |
up vote
2
down vote
accepted
The Generate Scripts wizard is unavailable because you are using a very old version of Management Studio Express. The 2012 version will work just fine against 2005 instances, but there is no longer an Express edition anyway, because all of the SSMS features are now available without any license.
Download the latest versions here:
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
I list downloads for the older versions at the bottom of this post:
https://blogs.sentryone.com/team-posts/latest-builds-management-studio/
answered Feb 11 '13 at 13:31
Aaron Bertrand
205k27357401
I selected this as the answer. I used 2005 as this is what was available on the server. However, I did install 2008 locally (not express) and the option to download structure AND data is available, and currently running. Cheers
– QMKevin
Feb 11 '13 at 19:38
add a comment |
up vote
2
down vote
accepted
up vote
2
down vote
accepted
The Generate Scripts wizard is unavailable because you are using a very old version of Management Studio Express. The 2012 version will work just fine against 2005 instances, but there is no longer an Express edition anyway, because all of the SSMS features are now available without any license.
Download the latest versions here:
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
I list downloads for the older versions at the bottom of this post:
https://blogs.sentryone.com/team-posts/latest-builds-management-studio/
answered Feb 11 '13 at 13:31
Aaron Bertrand
205k27357401
The Generate Scripts wizard is unavailable because you are using a very old version of Management Studio Express. The 2012 version will work just fine against 2005 instances, but there is no longer an Express edition anyway, because all of the SSMS features are now available without any license.
Download the latest versions here:
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
I list downloads for the older versions at the bottom of this post:
https://blogs.sentryone.com/team-posts/latest-builds-management-studio/
answered Feb 11 '13 at 13:31
Aaron Bertrand
205k27357401
edited Nov 10 at 21:35
answered Feb 11 '13 at 13:31
Aaron Bertrand
205k27357401
answered Feb 11 '13 at 13:31
Aaron Bertrand
205k27357401
answered Feb 11 '13 at 13:31
Aaron Bertrand
205k27357401
205k27357401
I selected this as the answer. I used 2005 as this is what was available on the server. However, I did install 2008 locally (not express) and the option to download structure AND data is available, and currently running. Cheers
– QMKevin
Feb 11 '13 at 19:38
add a comment |
I selected this as the answer. I used 2005 as this is what was available on the server. However, I did install 2008 locally (not express) and the option to download structure AND data is available, and currently running. Cheers
– QMKevin
Feb 11 '13 at 19:38
I selected this as the answer. I used 2005 as this is what was available on the server. However, I did install 2008 locally (not express) and the option to download structure AND data is available, and currently running. Cheers
– QMKevin
Feb 11 '13 at 19:38
I selected this as the answer. I used 2005 as this is what was available on the server. However, I did install 2008 locally (not express) and the option to download structure AND data is available, and currently running. Cheers
– QMKevin
Feb 11 '13 at 19:38
add a comment |
up vote
1
down vote
Backups do generate locally. That is to be expected, as your team has already told you. You can generate it locally and then download it with a tool such as an FTP client. I highly recommend Redgate tools. See http://www.red-gate.com/products/dba/sql-backup/ It's a great tool and has some network backup options built in to ship your backups elsewhere. If it's a one-time thing, Redgate also has tools for that too, e.g. SQL Compare and SQL Data Compare.
The solution you pick really depends on how frequently you have to run and download backups locally and how big the DB is.
answered Feb 11 '13 at 13:32
Eli Gassert
8,57621935
Unfortuantely I have no access to the DB Server, so cannot get teh file once it's downloaded. Neither do I have info on the network used by the 3rd party, so I cannot save the file via the network to an FTP site. This is a one-time deal, so Aaron's solution works best for me. Thanks though
– QMKevin
Feb 11 '13 at 19:37
add a comment |
up vote
1
down vote
Backups do generate locally. That is to be expected, as your team has already told you. You can generate it locally and then download it with a tool such as an FTP client. I highly recommend Redgate tools. See http://www.red-gate.com/products/dba/sql-backup/ It's a great tool and has some network backup options built in to ship your backups elsewhere. If it's a one-time thing, Redgate also has tools for that too, e.g. SQL Compare and SQL Data Compare.
The solution you pick really depends on how frequently you have to run and download backups locally and how big the DB is.
answered Feb 11 '13 at 13:32
Eli Gassert
8,57621935
Unfortuantely I have no access to the DB Server, so cannot get teh file once it's downloaded. Neither do I have info on the network used by the 3rd party, so I cannot save the file via the network to an FTP site. This is a one-time deal, so Aaron's solution works best for me. Thanks though
– QMKevin
Feb 11 '13 at 19:37
add a comment |
up vote
1
down vote
up vote
1
down vote
Backups do generate locally. That is to be expected, as your team has already told you. You can generate it locally and then download it with a tool such as an FTP client. I highly recommend Redgate tools. See http://www.red-gate.com/products/dba/sql-backup/ It's a great tool and has some network backup options built in to ship your backups elsewhere. If it's a one-time thing, Redgate also has tools for that too, e.g. SQL Compare and SQL Data Compare.
The solution you pick really depends on how frequently you have to run and download backups locally and how big the DB is.
answered Feb 11 '13 at 13:32
Eli Gassert
8,57621935
Backups do generate locally. That is to be expected, as your team has already told you. You can generate it locally and then download it with a tool such as an FTP client. I highly recommend Redgate tools. See http://www.red-gate.com/products/dba/sql-backup/ It's a great tool and has some network backup options built in to ship your backups elsewhere. If it's a one-time thing, Redgate also has tools for that too, e.g. SQL Compare and SQL Data Compare.
The solution you pick really depends on how frequently you have to run and download backups locally and how big the DB is.
answered Feb 11 '13 at 13:32
Eli Gassert
8,57621935
answered Feb 11 '13 at 13:32
Eli Gassert
8,57621935
answered Feb 11 '13 at 13:32
Eli Gassert
8,57621935
answered Feb 11 '13 at 13:32
Eli Gassert
8,57621935
8,57621935
Unfortuantely I have no access to the DB Server, so cannot get teh file once it's downloaded. Neither do I have info on the network used by the 3rd party, so I cannot save the file via the network to an FTP site. This is a one-time deal, so Aaron's solution works best for me. Thanks though
– QMKevin
Feb 11 '13 at 19:37
add a comment |
Unfortuantely I have no access to the DB Server, so cannot get teh file once it's downloaded. Neither do I have info on the network used by the 3rd party, so I cannot save the file via the network to an FTP site. This is a one-time deal, so Aaron's solution works best for me. Thanks though
– QMKevin
Feb 11 '13 at 19:37
Unfortuantely I have no access to the DB Server, so cannot get teh file once it's downloaded. Neither do I have info on the network used by the 3rd party, so I cannot save the file via the network to an FTP site. This is a one-time deal, so Aaron's solution works best for me. Thanks though
– QMKevin
Feb 11 '13 at 19:37
Unfortuantely I have no access to the DB Server, so cannot get teh file once it's downloaded. Neither do I have info on the network used by the 3rd party, so I cannot save the file via the network to an FTP site. This is a one-time deal, so Aaron's solution works best for me. Thanks though
– QMKevin
Feb 11 '13 at 19:37
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f14812958%2fexport-sql-database-all-tables-from-remote-server%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
