How can I migrate all objects alogwith all constraints,SP,Triggers etc from Development instance

Hi fellows,

I have to migrate all objects alogwith all constraints,SP,Triggers, indexes etc from Development instance to Production instance of a DB, all those things are created through wizard ie. Sql server 2000 Enterprise Manager. if i use DTS it only mirates data along with tables and views but constraints,SP,Triggers, indexes etc not yet copied.

can any body help me how can I solve this problem by copying all objects alogwith all constraints,SP,Triggers etc from Development instance to Production instance.

This is Sql server 2000 Cluster environment.

thanks in advance for any help

rahman

I would script all the objects out using Enterprise Manager and then run them all in the other environment.

-Jamie

|||

Dear Jamie

Thank you very much for your reply

would you like to give me a hence to write script for all the object's constraints (ie. Default,Check,Primary Key, Foreign Key etc) and indexes using Enterprise Manager.

I am new in SQL Server

Thanks in advance

|||

1. Right-click on an object.

2. Point at All tasks--> Generate SQL Script...

-Jamie

|||

Dear Jamie

Thanks for your reply.

I know this script only create table/view but not any constrains attached with it. As you know DTS also creates Table/views and imports the data too.

it'll not solve the problem, I m trying to write scripts for constraints getting info. from some views of Information_Schema.

|||

Thanks Jamie,

I didn't see the options available in Options Tab of All tasks--> Generate SQL Script

thank you very much

sql

How can I migrate all objects alogwith all constraints,SP,Triggers etc from Development inst

Hi fellows,

I have to migrate all objects alogwith all constraints,SP,Triggers, indexes etc from Development instance to Production instance of a DB, all those things are created through wizard ie. Sql server 2000 Enterprise Manager. if i use DTS it only mirates data along with tables and views but constraints,SP,Triggers, indexes etc not yet copied.

can any body help me how can I solve this problem by copying all objects alogwith all constraints,SP,Triggers etc from Development instance to Production instance.

This is Sql server 2000 Cluster environment.

thanks in advance for any help

rahman

I would script all the objects out using Enterprise Manager and then run them all in the other environment.

-Jamie

|||

Dear Jamie

Thank you very much for your reply

would you like to give me a hence to write script for all the object's constraints (ie. Default,Check,Primary Key, Foreign Key etc) and indexes using Enterprise Manager.

I am new in SQL Server

Thanks in advance

|||

1. Right-click on an object.

2. Point at All tasks--> Generate SQL Script...

-Jamie

|||

Dear Jamie

Thanks for your reply.

I know this script only create table/view but not any constrains attached with it. As you know DTS also creates Table/views and imports the data too.

it'll not solve the problem, I m trying to write scripts for constraints getting info. from some views of Information_Schema.

|||

Thanks Jamie,

I didn't see the options available in Options Tab of All tasks--> Generate SQL Script

thank you very much

How can I log DDL?

Hallo,
in Oracle I use DDL-Trigger. But how can I document/triggering DDL (for instance "alter table") in Microsoft SQL Server?
Regards, Doreenwhich version of SQL server are you using? DDL triggers are introduced in SQL Server 2005.|||I have to create a history of tables. Therefore I must know the previous structure of the table. I have to document the changes of the structures of the tables.
Is there a solution for the version 2000?

How can I have SQL 9.0 instance in management studio

I've installed SQL Server 2005 and SQL Server 2000 side by side.

Now when I open SQL Server Management Studio it runs the SQL version 8 that belongs to SQL Server 2000.

How can I start with SQL Server 2005 (SQL 9.0) to create new database under the new features?

thank you.

First, register the SQL 2005 instance...click 'view...registered servers'...then, in the registered servers window, register your SQL 2005 instance appropriately.

Once you've registered the server, right click on it and choose 'connect...object explorer'. If the Object Explorer pane isn't viewable, make it so by choosing 'view...object explorer' from the menus. Then, in Object Explorer simply expand the instance to view all objects, nodes, etc.

HTH

|||

Thanks Chad,

I have two Instances of SQL Server. one is ServerName which is based on SQL 8.0 (2000) and another one is ServerName/SQLEXPRESS based on SQL 9.0.

If I want to work with features in SQL Server 2005 I have to choose SQLEXPRESS instance.

I don't sure about SQL Server Express edition. only I know it has fewer features rather than SQL Server 2005 Enterprise edition.

I really want an instance of SQL Server 2005 Enterprise edition.

What can I do?

Thanks Chad.

|||

I see. Well, if you're going to use the instance for development use only, your best bet is to get a copy of the Developer Edition, which is exactly the same as the Enterprise Edition, however it is not licensed for commercial/production use, only developmental/test/demo use.

If you want an Enterprise Version, then you'd need to purchase it.

Alternatively, you could download a 180-day trial version for free as well.

Do you have an MSDN subscription? If so, you can download the developer edition and use it. If not, you'll have to purchase it as well.

Go here for more information on the developer edition, trial edition, and information on how to get them:

http://www.microsoft.com/sql/editions/developer/default.mspx

HTH

How can I get the port of a named instance of SQL Server

Thanks for Microsoft's Windows XP Service Pack 2 and Windows Server 2003 that make the security much stronger. However, besides the invisible benefit so far, I have become the victim of this security policy.

I have several named instances of SQL 7/2000 installed in my machine. They are not visible out of the Microsoft new fire wall. I need to access the instances from outside the fire wall, but I don't know which port I should open for the instances.

From SQL online, the default instance of SQL server is connected through TCP/IP by default port 1433. I could successful open that port and made the default instance visible to outside. However, the port 1433 doesn't work for the named instances. SQL online said, the port for named instance is dynamically (by default) chosen the first time the instance is started. So, actually, I have no way to know the port.

Is there anyway that I can check the database or somewhere to get the port that is used by the named instance?

Thanks for any input and recommendation.> I am the first victim of this security policy.

don't kid yourself. a lot of people have been caught out - many by inadequate preparation or by a simple naivete. your problem seems more of an actual gotcha though.

try turning off the firewall and doing a netstat -a|||Hi, Atrax, thanks for your input. But, ...|||wtf? I didn't follow that at all.|||Never mind.

By the way, I got the solution for the original question. Using SQL Server Network Utility can find all ports for default and named instances.

How Can I generate a rdl file from a mdx query in VB.net or C#.net?

Is there some methods to generate the rdl file or reporting html page from a given mdx query language
For instance, I have a mdx query:
select dim1.a on rows, dim2.b on columns from cub1
How can I generate the corresponding rdl file to generate report html page with VB.net or C#.net?

I know that one can use xmltextwriter to write the rdl file but it is a difficult work.Is there some internal class in Vistual Studio have some methods to generate the rdl file?

Thanks

There's a good article here on this:

http://msdn2.microsoft.com/en-us/library/ms167274.aspx

There's also some 3rd party libraries out there.

http://www.rdlcomponents.com/