Moving From Developer To Professional

[Blauther]

I have MS SQL Server 2000 Developer running on one machine, and I have MS Sql Server 2000 Professional running on another machine.

SQL Developer is obviously my development environment, and SQL Professional is the production environment.

My question is...after developing all of my tables, stored procedures, and permissions in the development environment, how do I get them to the production environment?

Any help would be greatly appreciated!

--Brian
BrianLauther@SoundSoftware.cc

 

[RickCole]

Back up your development databases and then restore them onto productions databases in the production environment.

Rick.

 

[Blauther]

Thank you Rick...That worked much better than the other way that I was doing this!