Hi,
This requirement is for our development and test environment. We have
a database server which we use for development hence many changes are
done on the database objects on daily basis like tables def changes,
view def changes, sp changes, new sp etc.
On the other hand our testing team connects to another database server
where they perform testing hence any internal test release would need
the changes like tables def changes, view def changes, sp changes, new
sp etc.
Since testing team already have their test data set in the test
environment hence they want to keep their data but new test release
should only provide with datbase object changes.
I dont do database admin job hence clueless as what would be the best
way to accomplish the above. Pl advice.
we are using sql server 2005 on both test and dev environemts.
cheers!
d2
D2
Visit at http://www.red-gate.com/products/SQL_Compare/index.htm
"D2" <dhapola@.yahoo.com> wrote in message
news:1185784582.666495.164430@.x35g2000prf.googlegr oups.com...
> Hi,
> This requirement is for our development and test environment. We have
> a database server which we use for development hence many changes are
> done on the database objects on daily basis like tables def changes,
> view def changes, sp changes, new sp etc.
> On the other hand our testing team connects to another database server
> where they perform testing hence any internal test release would need
> the changes like tables def changes, view def changes, sp changes, new
> sp etc.
> Since testing team already have their test data set in the test
> environment hence they want to keep their data but new test release
> should only provide with datbase object changes.
> I dont do database admin job hence clueless as what would be the best
> way to accomplish the above. Pl advice.
> we are using sql server 2005 on both test and dev environemts.
> cheers!
> d2
>
|||* D2 wrote, On 30-7-2007 10:36:
> Hi,
> This requirement is for our development and test environment. We have
> a database server which we use for development hence many changes are
> done on the database objects on daily basis like tables def changes,
> view def changes, sp changes, new sp etc.
> On the other hand our testing team connects to another database server
> where they perform testing hence any internal test release would need
> the changes like tables def changes, view def changes, sp changes, new
> sp etc.
> Since testing team already have their test data set in the test
> environment hence they want to keep their data but new test release
> should only provide with datbase object changes.
> I dont do database admin job hence clueless as what would be the best
> way to accomplish the above. Pl advice.
> we are using sql server 2005 on both test and dev environemts.
> cheers!
> d2
>
If you're using Visual Studio Team System, have a look at the new
Database professional add-in for the suite.
http://msdn2.microsoft.com/en-us/teamsystem/aa718807.aspx
I can also heartily recommend Red-gate SQL Compare, I've used that
product many times before with great results:
http://www.red-gate.com/products/SQL_Compare/index.htm
Jesse
|||I like xsql. http://www.xsqlsoftware.com/Main.aspx
They have an sdk which is very handy for custom applications.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"D2" <dhapola@.yahoo.com> wrote in message
news:1185784582.666495.164430@.x35g2000prf.googlegr oups.com...
> Hi,
> This requirement is for our development and test environment. We have
> a database server which we use for development hence many changes are
> done on the database objects on daily basis like tables def changes,
> view def changes, sp changes, new sp etc.
> On the other hand our testing team connects to another database server
> where they perform testing hence any internal test release would need
> the changes like tables def changes, view def changes, sp changes, new
> sp etc.
> Since testing team already have their test data set in the test
> environment hence they want to keep their data but new test release
> should only provide with datbase object changes.
> I dont do database admin job hence clueless as what would be the best
> way to accomplish the above. Pl advice.
> we are using sql server 2005 on both test and dev environemts.
> cheers!
> d2
>
Showing posts with label havea. Show all posts
Showing posts with label havea. Show all posts
Sunday, March 11, 2012
Copy database changes without data
Hi,
This requirement is for our development and test environment. We have
a database server which we use for development hence many changes are
done on the database objects on daily basis like tables def changes,
view def changes, sp changes, new sp etc.
On the other hand our testing team connects to another database server
where they perform testing hence any internal test release would need
the changes like tables def changes, view def changes, sp changes, new
sp etc.
Since testing team already have their test data set in the test
environment hence they want to keep their data but new test release
should only provide with datbase object changes.
I dont do database admin job hence clueless as what would be the best
way to accomplish the above. Pl advice.
we are using sql server 2005 on both test and dev environemts.
cheers!
d2D2
Visit at http://www.red-gate.com/products/SQL_Compare/index.htm
"D2" <dhapola@.yahoo.com> wrote in message
news:1185784582.666495.164430@.x35g2000prf.googlegroups.com...
> Hi,
> This requirement is for our development and test environment. We have
> a database server which we use for development hence many changes are
> done on the database objects on daily basis like tables def changes,
> view def changes, sp changes, new sp etc.
> On the other hand our testing team connects to another database server
> where they perform testing hence any internal test release would need
> the changes like tables def changes, view def changes, sp changes, new
> sp etc.
> Since testing team already have their test data set in the test
> environment hence they want to keep their data but new test release
> should only provide with datbase object changes.
> I dont do database admin job hence clueless as what would be the best
> way to accomplish the above. Pl advice.
> we are using sql server 2005 on both test and dev environemts.
> cheers!
> d2
>|||* D2 wrote, On 30-7-2007 10:36:
> Hi,
> This requirement is for our development and test environment. We have
> a database server which we use for development hence many changes are
> done on the database objects on daily basis like tables def changes,
> view def changes, sp changes, new sp etc.
> On the other hand our testing team connects to another database server
> where they perform testing hence any internal test release would need
> the changes like tables def changes, view def changes, sp changes, new
> sp etc.
> Since testing team already have their test data set in the test
> environment hence they want to keep their data but new test release
> should only provide with datbase object changes.
> I dont do database admin job hence clueless as what would be the best
> way to accomplish the above. Pl advice.
> we are using sql server 2005 on both test and dev environemts.
> cheers!
> d2
>
If you're using Visual Studio Team System, have a look at the new
Database professional add-in for the suite.
http://msdn2.microsoft.com/en-us/te...m/aa718807.aspx
I can also heartily recommend Red-gate SQL Compare, I've used that
product many times before with great results:
http://www.red-gate.com/products/SQL_Compare/index.htm
Jesse|||I like xsql. http://www.xsqlsoftware.com/Main.aspx
They have an sdk which is very handy for custom applications.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"D2" <dhapola@.yahoo.com> wrote in message
news:1185784582.666495.164430@.x35g2000prf.googlegroups.com...
> Hi,
> This requirement is for our development and test environment. We have
> a database server which we use for development hence many changes are
> done on the database objects on daily basis like tables def changes,
> view def changes, sp changes, new sp etc.
> On the other hand our testing team connects to another database server
> where they perform testing hence any internal test release would need
> the changes like tables def changes, view def changes, sp changes, new
> sp etc.
> Since testing team already have their test data set in the test
> environment hence they want to keep their data but new test release
> should only provide with datbase object changes.
> I dont do database admin job hence clueless as what would be the best
> way to accomplish the above. Pl advice.
> we are using sql server 2005 on both test and dev environemts.
> cheers!
> d2
>|||I recommend ApexSQL Diff. http://www.apexsql.com/sql_tools_diff.asp
TheSQLGuru
President
Indicium Resources, Inc.
"D2" <dhapola@.yahoo.com> wrote in message
news:1185784582.666495.164430@.x35g2000prf.googlegroups.com...
> Hi,
> This requirement is for our development and test environment. We have
> a database server which we use for development hence many changes are
> done on the database objects on daily basis like tables def changes,
> view def changes, sp changes, new sp etc.
> On the other hand our testing team connects to another database server
> where they perform testing hence any internal test release would need
> the changes like tables def changes, view def changes, sp changes, new
> sp etc.
> Since testing team already have their test data set in the test
> environment hence they want to keep their data but new test release
> should only provide with datbase object changes.
> I dont do database admin job hence clueless as what would be the best
> way to accomplish the above. Pl advice.
> we are using sql server 2005 on both test and dev environemts.
> cheers!
> d2
>
This requirement is for our development and test environment. We have
a database server which we use for development hence many changes are
done on the database objects on daily basis like tables def changes,
view def changes, sp changes, new sp etc.
On the other hand our testing team connects to another database server
where they perform testing hence any internal test release would need
the changes like tables def changes, view def changes, sp changes, new
sp etc.
Since testing team already have their test data set in the test
environment hence they want to keep their data but new test release
should only provide with datbase object changes.
I dont do database admin job hence clueless as what would be the best
way to accomplish the above. Pl advice.
we are using sql server 2005 on both test and dev environemts.
cheers!
d2D2
Visit at http://www.red-gate.com/products/SQL_Compare/index.htm
"D2" <dhapola@.yahoo.com> wrote in message
news:1185784582.666495.164430@.x35g2000prf.googlegroups.com...
> Hi,
> This requirement is for our development and test environment. We have
> a database server which we use for development hence many changes are
> done on the database objects on daily basis like tables def changes,
> view def changes, sp changes, new sp etc.
> On the other hand our testing team connects to another database server
> where they perform testing hence any internal test release would need
> the changes like tables def changes, view def changes, sp changes, new
> sp etc.
> Since testing team already have their test data set in the test
> environment hence they want to keep their data but new test release
> should only provide with datbase object changes.
> I dont do database admin job hence clueless as what would be the best
> way to accomplish the above. Pl advice.
> we are using sql server 2005 on both test and dev environemts.
> cheers!
> d2
>|||* D2 wrote, On 30-7-2007 10:36:
> Hi,
> This requirement is for our development and test environment. We have
> a database server which we use for development hence many changes are
> done on the database objects on daily basis like tables def changes,
> view def changes, sp changes, new sp etc.
> On the other hand our testing team connects to another database server
> where they perform testing hence any internal test release would need
> the changes like tables def changes, view def changes, sp changes, new
> sp etc.
> Since testing team already have their test data set in the test
> environment hence they want to keep their data but new test release
> should only provide with datbase object changes.
> I dont do database admin job hence clueless as what would be the best
> way to accomplish the above. Pl advice.
> we are using sql server 2005 on both test and dev environemts.
> cheers!
> d2
>
If you're using Visual Studio Team System, have a look at the new
Database professional add-in for the suite.
http://msdn2.microsoft.com/en-us/te...m/aa718807.aspx
I can also heartily recommend Red-gate SQL Compare, I've used that
product many times before with great results:
http://www.red-gate.com/products/SQL_Compare/index.htm
Jesse|||I like xsql. http://www.xsqlsoftware.com/Main.aspx
They have an sdk which is very handy for custom applications.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"D2" <dhapola@.yahoo.com> wrote in message
news:1185784582.666495.164430@.x35g2000prf.googlegroups.com...
> Hi,
> This requirement is for our development and test environment. We have
> a database server which we use for development hence many changes are
> done on the database objects on daily basis like tables def changes,
> view def changes, sp changes, new sp etc.
> On the other hand our testing team connects to another database server
> where they perform testing hence any internal test release would need
> the changes like tables def changes, view def changes, sp changes, new
> sp etc.
> Since testing team already have their test data set in the test
> environment hence they want to keep their data but new test release
> should only provide with datbase object changes.
> I dont do database admin job hence clueless as what would be the best
> way to accomplish the above. Pl advice.
> we are using sql server 2005 on both test and dev environemts.
> cheers!
> d2
>|||I recommend ApexSQL Diff. http://www.apexsql.com/sql_tools_diff.asp
TheSQLGuru
President
Indicium Resources, Inc.
"D2" <dhapola@.yahoo.com> wrote in message
news:1185784582.666495.164430@.x35g2000prf.googlegroups.com...
> Hi,
> This requirement is for our development and test environment. We have
> a database server which we use for development hence many changes are
> done on the database objects on daily basis like tables def changes,
> view def changes, sp changes, new sp etc.
> On the other hand our testing team connects to another database server
> where they perform testing hence any internal test release would need
> the changes like tables def changes, view def changes, sp changes, new
> sp etc.
> Since testing team already have their test data set in the test
> environment hence they want to keep their data but new test release
> should only provide with datbase object changes.
> I dont do database admin job hence clueless as what would be the best
> way to accomplish the above. Pl advice.
> we are using sql server 2005 on both test and dev environemts.
> cheers!
> d2
>
Wednesday, March 7, 2012
Copy and move the database to another server
I have a SQL Server database(NWind) available in a stand alone server. I have
a CD writer in this stand alone server. I need to create an instance of this
NWind database into another server.
How can I copy the database from my first server into my second server.
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546
|||If I use Detach database does the database in the first server be still
available once I move it to another server.
"Shadow" wrote:
> HOW TO: Move Databases Between Computers That Are Running SQL Server
> http://support.microsoft.com/?id=314546
>
a CD writer in this stand alone server. I need to create an instance of this
NWind database into another server.
How can I copy the database from my first server into my second server.
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546
|||If I use Detach database does the database in the first server be still
available once I move it to another server.
"Shadow" wrote:
> HOW TO: Move Databases Between Computers That Are Running SQL Server
> http://support.microsoft.com/?id=314546
>
Copy and move the database to another server
I have a SQL Server database(NWind) available in a stand alone server. I hav
e
a CD writer in this stand alone server. I need to create an instance of this
NWind database into another server.
How can I copy the database from my first server into my second server.HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546|||If I use Detach database does the database in the first server be still
available once I move it to another server.
"Shadow" wrote:
> HOW TO: Move Databases Between Computers That Are Running SQL Server
> http://support.microsoft.com/?id=314546
>
e
a CD writer in this stand alone server. I need to create an instance of this
NWind database into another server.
How can I copy the database from my first server into my second server.HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546|||If I use Detach database does the database in the first server be still
available once I move it to another server.
"Shadow" wrote:
> HOW TO: Move Databases Between Computers That Are Running SQL Server
> http://support.microsoft.com/?id=314546
>
Subscribe to:
Comments (Atom)